SQL语句去掉重复记录，获取重复记录实例代码

SELECT MIN(UserID) AS UserID, RoleID FROM tmpTable GROUP BY RoleID SELECT RoleID FROM tmpTable GROUP BY RoleID HAVING (COUNT(*) > 1) SELECT DISTINCT * FROM tmpTable

select name from sysobjects where type='U'

Select name from syscolumns Where ID=OBJECT_ID('表名') select * from information_schema.tables select * from information_schema.views select * from information_schema.columns

select name from MSysObjects where type=1 and flags=0