HashFlare
Tags Posts tagged with "视觉 VIDEO"

视觉 VIDEO

all videos

天朝同胞可以看优酷

/****** Script for TEST BY ly ******/

首先我们先看下原始数据

SELECT * FROM [GroupData1].[dbo].[Group2]

然后我们筛选出email

SELECT t.QUNNum AS QUNNum,STUFF(
(SELECT ‘@qq.com,’ + CAST(s.QQNum as varchar(100))
FROM [GroupData1].[dbo].[Group2] s
WHERE s.QUNNum=t.QUNNum
FOR XML PATH(”)),1,8,”) + ‘@qq.com’ AS Email
FROM [GroupData1].[dbo].[Group2] t
group by t.QUNNum;

最后用bcp命令生成excel

bcp “SELECT t.QUNNum AS QUNNum,STUFF((SELECT ‘@qq.com,’ + CAST(s.QQNum as varchar(100)) FROM [GroupData1].[dbo].[Group2] s WHERE s.QUNNum=t.QUNNum FOR XML PATH(”)),1,8,”) + ‘@qq.com’ AS Email FROM [GroupData1].[dbo].[Group2] t group by t.QUNNum” queryout Email.xls -c -T -U ‘sa’ -P ‘123456’ -S localhost\sqlexpress

其实上面没有过滤掉重复的Email,稍微改下就可以了,自己动脑吧

0 2326
新加坡harborfront vivocity 海滨步行道走过去就看到,每晚9点,no charge,10分钟表演,开场前的音乐也挺好听的

您还没有安装flash播放器,请点击这里安装

回来的路上一个酒吧的人们突然自嗨起来,不知道是求婚还是什么

您还没有安装flash播放器,请点击这里安装

RANDOM POSTS

0 1344
Although this Articles simply collects and gathers links for all front-end developer's or designer's reference, but it's really important to introduce or remind us...