HashFlare
Video
reserved for theme

0 2315

#迪拜摇#太洗脑了!短短几天就风靡网络,引爆全民狂摇!简直是居家旅行、朋友聚会、年会晚会必备!只要记住口诀:左插右插下插上插右摸左摸,十秒就学会了!so easy!青春就要摇摆,快跟着节奏,摇动你们的身体吧!音乐:迪拜电子,请在美拍在线音乐下载。转发给小伙伴,一起摇起来!看完记得点个赞,还不过瘾的话,快去广场围观更多迪拜摇吧!
引用,去美拍看看

天朝同胞可以看优酷

/****** 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...