摘要：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...
阅读全文
摘要：string text = "Yeah, you clicked the button!";EventHandler handler =delegate(object dlgSender, EventArgs dlgE){ Response.Write(text);};this.Button1.Click += handler;
阅读全文
摘要：function fn(a,b,c){ var s = ""; var i; s += "函数传入参数个数:" + fn.arguments.length + "\n"; for (i=0;i<fn.arguments.length;i++) { s += "函数传入参数" + i +":" + fn.arguments[i] + "\n"; }...
阅读全文
摘要：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...
阅读全文
