随笔分类 -  [03]SQL Server

SQL Server使用命令修改表名或表的列名
摘要：1、重命名表将表OLD重命名为NEW：EXEC sp_rename 'OLD','NEW'GO2、重命名列将表table1中的列old重命名为new：EXEC sp_rename 'table1.old'，'new','COLUMN'GO 阅读全文
posted @ 2015-09-07 10:43 [在路上ing] 阅读(1791) 评论(0) 推荐(0)
SQL Server中Group分组获取Top N方法实现
摘要：1、采用row_number方法。SELECT *FROM (SELECT RowNumber =row_number() OVER (PARTITION BY TaskID ORDER BY ProduceDate DESC), * FROM dbo.ShippingDocument)tWHERE... 阅读全文
posted @ 2015-09-01 10:11 [在路上ing] 阅读(342) 评论(0) 推荐(0)