exec中执行多条语句的问题

[proud]

比如:
exec('select * from table1')
exec('select * from table2')
exec('select * from table3')
想在一条exec中完成
也就是:
exec('select * from table1' + 'select * from table2' + 'select * from table3')
可是执行不了,请问怎么解决?

[mugua604]

可以啊！！
exec（'select * from table1 select * from table2 select * from table3'）

[让你望见影子的墙]

declare @s varchar(8000)
set @s='select * from tb;select * from tb1;select * from tb2'
exec (@s)

[kuangdp]

[Quote=引用楼主 proud 的帖子:]
比如:
exec('select * from table1')
exec('select * from table2')
exec('select * from table3')
想在一条exec中完成
也就是:
exec('select * from table1' + 'select * from table2' + 'select * from table2' )
可是执行不了,请问怎么解决?
[/Quote]

写的太紧了，你这样成了 select * from table1select * from table2select * from table2

肯定报错啊 加空格或者；什么的都可以执行