alter procedure modify_table
as
declare @a varchar(50),@sql varchar(max)
set @a=''
select @a=max(ws.name) from opendatasource('SQLOLEDB','data source=lucky;uid=sa;pwd=密码').WoLucky_DATA.dbo.sysobjects as ws left join sysobjects as s on ws.name=s.name where ws.[xtype]='U' and s.name is null
while(len(@a)>0)
begin
set @sql=''
if (object_id(@a) is null)
begin
set @sql+='select * into '+quotename(@a)+' from opendatasource(''SQLOLEDB'',''data source=lucky;uid=sa;pwd=密码'').WoLucky_DATA.dbo.'+quotename(@a)+''
set @sql+=' alter table '+quotename(@a)+' drop column id'
set @sql+=' alter table '+quotename(@a)+' add ID int identity(1,1)'
exec(@sql)
end
select @a=max(ws.name) from opendatasource('SQLOLEDB','data source=lucky;uid=sa;pwd=lucky558').WoLucky_DATA.dbo.sysobjects as ws left join sysobjects as s on ws.name=s.name where ws.[xtype]='U' and s.name is null and ws.name<@a
end