日期:2014-05-17 浏览次数:20410 次
declare @i int
set @i=1
while @i<30
begin
insert into record values('xxxx','2013-12-23','aasa'+'@i')就是这里我想让插入'aasa'跟@i的结合(aasa1、aasa2...)
set @i=@i+1
end
declare @i int
set @i=1
while @i<30
BEGIN
DECLARE @n VARCHAR(10)
SET @n='aasa'+CONVERT(VARCHAR(2),@i)
insert into record values('xxxx','2013-12-23',@n)
set @i=@i+1
end