摘要:
转自:http://blog.itpub.net/14766526/viewspace-1156100/select GETDATE() as '当前日期',DateName(year,GetDate()) as '年',DateName(month,GetDate()) as '月',DateNa... 阅读全文
posted @ 2015-07-22 14:47
lui
阅读(11900)评论(0)推荐(0)
编辑
摘要:
select row_number() over(order by t.id ) as num,id,name from (SELECT distinct [列 0] as id ,[列 1] as name FROM MonitorSetup --order by [列 0] )t 阅读全文
posted @ 2015-07-02 11:52
lui
阅读(1825)评论(0)推荐(0)
编辑