摘要:
--删除重复数据(多字段)with m AS ( select *, row_number() over(PARTITION BY column1,column2,column3,column4,column5 ORDER by ValueAddedTaxGUID) rn FROM tableName ) delete m where rn > 1 阅读全文
摘要:
IF OBJECT_ID(N'usp_QueryAllTableFieldContent') IS NOT NULL BEGIN DROP PROC usp_QueryAllTableFieldContent END GO CREATE PROCEDURE usp_QueryAllTableFieldContent ( @queryFieldType VAR... 阅读全文
摘要:
--求存在相关字段的表,表会出现重复,同一个表的字段名不重复xtype=‘U’是表,xtype=‘V’是视图,xtype=‘P’ 是存储过程 SELECT syscolumns.name AS 字段名,sysobjects.name AS 表名 FROM syscolumns INNER JOIN 阅读全文