随笔分类 - SqlServer

SQL中分页与distinct冲突解决方案

摘要：SELECT list.* FROM(SELECT ROW_NUMBER() OVER(ORDER BY salesStatus.LastTime DESC,school.SchoolID DESC) AS rownumber, school.SchoolID,school.SchoolName,s 阅读全文

posted @ 2016-05-18 11:11 以勤补拙阅读(901) 评论(0) 推荐(0)

sql修改自增长ID

摘要：ALTER PROCEDURE [sp_Table_SetIdentity] @Table varchar(100) ,@Schema varchar(100) AS BEGIN DECLARE @vSQL nvarchar(max) -- drop PK on [SchoolID] SET @vSQL = N' ALTER... 阅读全文

posted @ 2016-03-21 16:52 以勤补拙阅读(1531) 评论(0) 推荐(0)