摘要： --------------------------删除单字段重复-----------------------------------------------If Exists(Select * From tempdb.Information_Schema.Tables Where Table_Name Like '#Temp%') Drop Table #temp Create Table #temp ([Id] int, [Name] varchar(50), [Age] int, [Sex] bit default 1) Go Insert Into #temp ([I 阅读全文

摘要： 例如：id name value1 a pp2 a pp3 b iii4 b pp5 b pp6 c pp7 c pp8 ... 阅读全文