1.找出表的字段名
select name from syscolumns where id in (select id from sysobjects where name='表名')
2.把id列自动编号的操作
declare @id int
set @id = 100000
update 表1 set @id = @id + 1,id = right(@id,5)
3.将A表中的重复行删除:创建临时表a,存入不重复的记录,然后删除A中所有记录,再把a插入到A中
select distinct * into a from A
delete from A
insert A
select * from a
4.删除记录中的空格:
update 表名
set name=rtrim(ltrim(name))