摘要：DECLARE @a table(i int)DECLARE @b table(i int)INSERT INTO @a SELECT 1 UNION ALL SELECT 2INSERT INTO @b SELECT 1 UNION ALL SELECT 3SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i =b.iSELECT a.i,... 阅读全文

摘要：是否支持多句查询http://www.xxx.com/xxxnews/shownews.asp?id=51;declare @a int-- 是否支持子查询http://www.xxx.com/xxxnews/shownews.asp?id=51 and (Select count(1) from [sysobjects])>=0 返回用户名http://www.xxx.com/xxxnews/... 阅读全文

摘要：SELECTLastNameFROMEmployeeORDERBYLastNameCOLLATETraditional_Spanish_ci_aiASC看红色的部份。现在可以按不同语言进行排序，的确方便不少。 阅读全文

摘要：浅析SQL SERVER一个没有公开的存储过程中介绍了sp_MSforeachtable的工作方式和工作原理。不过令人失望的是它们不能扩展到其它的对象（比如视图、存储过程、触发器等）。那我们就自己对手来完全扩展这些存储过程。 --sp_MSforeachsproc 存储过程USE MASTERGOif exists (select name from sysobjects ... 阅读全文

摘要：DECLARE @s datetime,@e datetimeSET @s = '1978-2-24' --写你的生日SET @e = getDate()+1DECLARE @y int,@m int,@d intSET @y = DATEDIFF(yy,@s,@e)SET @s = DATEADD(yy,@y,@s)SET @m = DATEDIFF(mm,@s,@e)SET @s = DAT... 阅读全文

摘要：SELECT * INTO t --载入测试数据FROM( SELECT 1 AS ID,'food' AS Product,0 AS ParentID UNION ALL SELECT 2,'sport',0 UNION ALL SELECT 3,'drink',1 UNION ALL SELECT 4,'ball',2 UNION ALL SELECT 5,'f... 阅读全文

摘要：DECLARE@tTABLE(studentvarchar(50),classvarchar(50),gradeint)INSERTINTO@tSELECT'孙小美','数学',10UNIONALLSELECT'孙小美','语文',20UNIONALLSELECT'孙小美','英语',30UNIONALLSELECT'阿土伯','数学',40UNIONALLSELECT'阿土伯','语文',50UNIONALLSELECT'阿土 阅读全文

摘要：DECLARE @t TABLE( id_num INT IDENTITY(1,1) UNIQUE CLUSTERED, i INT)INSERT INTO @t(i)SELECT 1 UNION ALLSELECT 1 UNION ALLSELECT 1 UNION ALLSELECT 2 UNION ALLSELECT 2 UNION ALLSELECT 3DELETE @tFR... 阅读全文

摘要：DECLARE @now datetime,@LastMonth datetimeDECLARE @star datetime,@end datetimeSET @now = DATEADD(dd,DATEDIFF(dd,'1900-1-1',getDATE()),'1900-1-1') --当前日期SET @LastMonth = DATEADD(mm,-1,@now) -- 上个月的今天S... 阅读全文

摘要：--处理示例--示例数据create table tb(ID int,Name varchar(10),ParentID int)insert tb select 1,'AAAA' ,0union all select 2,'BBBB' ,0union all select 3,'CCCC' ,0union all select 4,'AAAA-1' ,1union all ... 阅读全文

摘要：SELECT IDENTITY(int, 1,1) AS ID_Num into #t FROM sysobjectsSELECT COUNT(*) AS 天数,SUM(CASE DATEPART(weekday,dt) WHEN 1 THEN 0 WHEN 7 THEN 0 ELSE 1 END) AS 工作日FROM (SELECT DATEADD(dd,ID_NUM-1,get... 阅读全文

摘要：ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[customer_s]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[customer_s]GOCREATETABLE[dbo].[customer_s]([cus... 阅读全文

摘要：DECLARE @d smalldatetimeSET @d = '2004-7-1'SELECT IDENTITY(int,0,1) AS i INTO #t FROM sysobjectsSELECT MAX(M1) AS M1, MAX(M2) AS M2, MAX(M3) AS M3, MAX(M4) AS M4, MAX(M5) AS M5, MAX... 阅读全文

摘要：你要先安装,下面的阅读器 http://images.zinio.com/download/ZinioReader_2246818078.exe 然后就可以下最新的SQL server杂志了 http://www.zinio.com/download?b=RN nbsp; 你也可以到http://www.zinio.com/了解更多的杂志. 阅读全文