if exists(SELECT *
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.syscolumns.colstat = 1) And dbo.sysobjects.name ='表名')
begin
print '存在标识'
----下面将标识删除
select * into #tmp from 表名
declare @str varchar(8000)
set @str='alter table #tmp add coln int '
exec(@str)
set @str='update #tmp set coln= 标识'
exec(@str)
set @str='alter table #tmp drop column 标识'
exec(@str)
set @str='select *,identity(int,1,1) As Fid into #tmp2 From #tmp '
exec(@str)
exec('select * from #Tmp2')
end