2010年11月10日
类型空间
摘要： CREATETABLEtb4039(c1INTIDENTITY,c2CHAR(4035)NOTNULL)CREATETABLEtb4040(c1INTIDENTITY,c2CHAR(4036)NOTNULL)DECLARE@iINTSET@i=1WHILE@i<=100BEGININSERTINTOtb4039(c2)VALUES('test'+CONVERT(VARCHAR(5),@i))... 阅读全文
posted @ 2010-11-10 23:39 qanholas 阅读(331) 评论(0) 推荐(0) 编辑
Rollup and cube
摘要： CREATETABLE#temp(nameVARCHAR(20),jobVARCHAR(20),ageINT,COUNTINT)INSERT#tempSELECT'周杰伦','歌手',25,2010UNIONALLSELECT'周杰伦','歌手',26,1444INSERT#tempSELECT'刘德华','演员',40,1101UNIONALLSELECT'刘德华','演员',45,4664IN... 阅读全文
posted @ 2010-11-10 23:11 qanholas 阅读(248) 评论(0) 推荐(0) 编辑
杀死数据库连接
摘要： useMASTERdeclare@spidintdeclareCURcursorforselectspidfromsysprocesseswheredbid=(selectdbidfromsysdatabaseswherename='ycmis')opencurfetchnextfromCURinto@spidwhile@@FETCH_STATUS=0beginexec('KILL'+@spid)... 阅读全文
posted @ 2010-11-10 23:03 qanholas 阅读(454) 评论(1) 推荐(0) 编辑
all,any,some
摘要： selecttop1000*from费用表where费用ID<any(selecttop10(费用id)from费用表orderby费用IDasc)selecttop1000*from费用表where费用ID>all(selecttop10(费用id)from费用表orderby费用IDasc)selecttop1000*from费用表where费用ID<some(selectt... 阅读全文
posted @ 2010-11-10 22:24 qanholas 阅读(171) 评论(0) 推荐(0) 编辑