cengland0 (12/10/2010)
This should produce the same as (Notice no spacing between two commands):
Set @strSQL = 'Create table #tmp (id int)Insert into #tmp(id) values (1)'I knew this had to cause some error
Except it doesn't.
If you copy/paste the above in an SSMS query window and hit execute, you get "Command(s) completed successfully."