表只有一个字段num,我现在想插入记录1-50,就是要批量插入,我做的错在哪里呢?该怎样改正?
declare @t table(num varchar(10))
insert into @t
declare @num int
set @num=1
while @num<=50
begin
select @num,@num=@num+1
end服务器: 消息 156,级别 15,状态 1,行 3
在关键字 'declare' 附近有语法错误。
服务器: 消息 141,级别 15,状态 1,行 8
向变量赋值的 SELECT 语句不能与数据检索操作结合使用。
declare @t table(num varchar(10))
insert into @t
declare @num int
set @num=1
while @num<=50
begin
select @num,@num=@num+1
end服务器: 消息 156,级别 15,状态 1,行 3
在关键字 'declare' 附近有语法错误。
服务器: 消息 141,级别 15,状态 1,行 8
向变量赋值的 SELECT 语句不能与数据检索操作结合使用。
insert into @t
declare @num int
set @num=1
while @num<=50
begin
select @num
select @num=@num+1
end
--insert into @t
declare @num int
set @num=1
while @num<=50
begin
insert into @t
select @num
set @num=@num+1
end
select * from @t
insert into @t select 1
declare @num int
set @num=1
while @num<=50
begin
select @num
select @num=@num+1
end
declare @num INT
set @num=1
while @num<=50
begin
insert into @t select @num
set @num=@num+1
endSELECT * FROM @t
declare @t table(num varchar(10))
declare @num int
set @num=1
while @num<=50
begin
insert into @t values(@num)
set @num=@num+1
end
declare @t table(num varchar(10))
declare @num int
set @num=1
while @num<=50
begin
insert into @t
select @num
set @num=@num+1
end
insert into @t
declare @num int
set @num=1
while @num<=50
begin
insert into @t select @num
set @num=@num+1
end