sqlserver 修改字段类型,同表查询重复记录sql语句

来源:互联网 发布:mac搭建apache服务器 编辑:程序博客网 时间:2024/05/16 02:52
ALTER TABLE User ALTER COLUMN name varchar(150)
select * from leepay_GameSeries where [Name] in (select [Name] from leepay_GameSeries group by [Name] having count([Name])>1)