34,576
社区成员
发帖
与我相关
我的任务
分享
declare @str1 varchar(8000),@str2 varchar(8000)
set @str1 = 'alter table [tablename] add .......'
set @str2 = 'insert into [tablename] (.....) select .... from [TableSource] '
exec(@str1) --第一次使用exec
exec(@str2) --第二次使用exec
DECLARE @STR NVARCHAR(4000)
SET @STR='SELECT * FROM SYSOBJECTS'
DECLARE @STR1 NVARCHAR(4000)
SET @STR1='SELECT * FROM SYSOBJECTS'
DECLARE @STR2 NVARCHAR(4000)
SET @STR2=@STR+';'+@STR1
PRINT @STR2
EXEC(@STR2)
execute('select 123' + ' select ''sss''')
declare @s1 varchar(600),@s2 varchar(600)
set @s1 = 'select 123'
set @s2 = 'select ''sss'''
execute(@s1 + @s2)
declare @str1 varchar(8000),@str2 varchar(8000)
set @str1 = 'alter table [tablename] add .......; go'
set @str2 = 'insert into [tablename] (.....) select .... from [TableSource] '
exec(@str1+@str2)
declare @str1 varchar(8000),@str2 varchar(8000)
set @str1 = 'alter table [tablename] add .......;'
set @str2 = 'insert into [tablename] (.....) select .... from [TableSource] '
exec(@str1+@str2)