随笔分类 -  T-SQL

摘要：--查询语句SELECT [Table Name] = OBJECT_NAME(col.object_id), [Column Name] = col.name, [Description] = ex.value FROM sys.columns col LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = col.object_id AND ex.minor_id = col.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(col.o. 阅读全文

摘要：Person表原始数据如下图：IDNameSexCreatedOn1黄明男2011-12-262黄明男2011-12-263马圈女2011-12-284马圈女2011-12-28欲得到的结果是：IDNameSexCreatedOn1黄明男2011-12-263马圈女2011-12-28删除语句如下：with Source as (select ROW_NUMBER() OVER(PARTITION BY Name,Sex,CreatedOn ORDER BY ID) RowNumber,*from Person )delete from Person where ID in (select I 阅读全文