declare @tmp int set @tmp = 0update tabele set c = cast(@tmp as varchar(18)),@tmp = @tmp + 1
create proc p_insert_s @cnt int as declare @n int,@s varchar(16) set @n=1 set @s='' while @n<=@cnt begin set @s=cast(@n as varchar) insert into table(c) select @s @n=@n+1 end goexec('p_insert_s 50')
大力的语句: declare @i int set @i = 0 update table set c = @i,@i = @i + 1
declare @ int set @ = 0 update [table] set @=@+1,c=@
SELECT IDENTITY(INT,1,1) AS c,a,b INTO #aaa FROM tablenameDROP TABLE tablenameSELECT * INTO tablename FROM #aaa --SELECT * from tablename
declare @i int set @i=0 select @i=count(*) from yourtable where c is not null update table yourtable set c = @i,@i = @i + 1
as
declare @n int,@s varchar(16)
set @n=1
set @s=''
while @n<=@cnt
begin
set @s=cast(@n as varchar)
insert into table(c) select @s
@n=@n+1
end
goexec('p_insert_s 50')
declare @i int
set @i = 0
update table set c = @i,@i = @i + 1
set @ = 0
update [table] set @=@+1,c=@
FROM tablenameDROP TABLE tablenameSELECT * INTO tablename FROM #aaa --SELECT * from tablename
set @i=0
select @i=count(*) from yourtable where c is not null
update table yourtable set c = @i,@i = @i + 1