strSql_proc="if exists (select name from sysobjects where name='temp' and type='u')
drop table drop
go
declare @str char(1000)
select @str='zd char(10),zd1 char(10)'
exec('create table temp
('+@str+')')
declare @i int
select @i=2
declare @ins char(1000)
select @ins='insert into temp select zbdm,gsjd from zbj
insert into temp select zbdm,jdlx from zbj'
while @i>0
begin
exec(@ins)
select @i=@i-1
end"; 这样写有什么不对?为什么vs.net报错
drop table drop
go
declare @str char(1000)
select @str='zd char(10),zd1 char(10)'
exec('create table temp
('+@str+')')
declare @i int
select @i=2
declare @ins char(1000)
select @ins='insert into temp select zbdm,gsjd from zbj
insert into temp select zbdm,jdlx from zbj'
while @i>0
begin
exec(@ins)
select @i=@i-1
end"; 这样写有什么不对?为什么vs.net报错
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货