declare @a table( aa varchar(2),cc varchar(20)) declare @cc int set @cc=1 while @cc<10000 begin insert into @a select cast(right(rand(),2) as varchar(20)),'AAAA'+cast(@cc as varchar) set @cc=@cc+1 end select * from @a
declare @a table( aa varchar(2),cc varchar(20)) declare @cc int set @cc=1 while @cc<10000 begin insert into @a select cast(right(rand(),2) as varchar(20)),'AAAA'+left('0000',4-len(@cc))+cast(@cc as varchar) set @cc=@cc+1 end select * from @a
SET nocount ondeclare @a table( aa varchar(2),cc varchar(20)) declare @cc int set @cc=1 while @cc<10000 begin insert into @a select cast(right(rand(),2) as varchar(20)),'AAAA'+right('0000'+cast(@cc as varchar),4) set @cc=@cc+1 end select * from @a
declare @a table( aa varchar(2),cc varchar(20)) declare @cc int set @cc=1 while @cc<10000 begin insert into @a select cast(right(rand(),2) as varchar(20)),'AAAA'+left('0000',4-len(@cc))+cast(@cc as varchar) set @cc=@cc+1 end select * from @a update egadgset egadg.jdg = @a.aa我想接下去直接更新数据,我是这样做的,结果不行,应该怎样写? 服务器: 消息 137,级别 15,状态 2,行 11 必须声明变量 '@a'。
declare @cc int
set @cc=1
while @cc<10000
begin
insert into @a
select cast(right(rand(),2) as varchar(20)),'AAAA'+cast(@cc as varchar)
set @cc=@cc+1
end
select * from @a
declare @cc int
set @cc=1
while @cc<10000
begin
insert into @a
select cast(right(rand(),2) as varchar(20)),'AAAA'+left('0000',4-len(@cc))+cast(@cc as varchar)
set @cc=@cc+1
end
select * from @a
declare @cc int
set @cc=1
while @cc<10000
begin
insert into @a
select cast(right(rand(),2) as varchar(20)),'AAAA'+right('0000'+cast(@cc as varchar),4)
set @cc=@cc+1
end
select * from @a
declare @cc int
set @cc=1
while @cc<10000
begin
insert into @a
select cast(right(rand(),2) as varchar(20)),'AAAA'+left('0000',4-len(@cc))+cast(@cc as varchar)
set @cc=@cc+1
end
select * from @a
update egadgset egadg.jdg = @a.aa我想接下去直接更新数据,我是这样做的,结果不行,应该怎样写?
服务器: 消息 137,级别 15,状态 2,行 11
必须声明变量 '@a'。