07 2011 档案

摘要：SqlServer之Convert 函数应用Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1): 05/16/06Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06Select C 阅读全文

摘要：sql查询的时候有时候要加上行号，这里做个备忘~1(建议采用),select row_number() over (order by col1) as no,newid() as id,*from Table1order by col12,select no=identity(int,1,1),newid() as id,* into #temptable From Table1order by col1Select * From #temptableDrop Table #temptable3,SELECT (SELECT sum(1) FROMTable1WHEREcol1 <= a 阅读全文