if object_id(@tablename) is null exec ('select a.name ,b.val into ' + @tablename + ' from a,b where a.id=b.id') else exec ('insert ' + @tablename + ' a.name ,b.val from a,b where a.id=b.id')
if object_id(@tablename) is null exec ('select a.name ,b.val into ' + @tablename + ' from a,b where a.id=b.id') else exec ('insert ' + @tablename + ' select a.name ,b.val from a,b where a.id=b.id')
exec ('select a.name ,b.val into ' + @tablename + ' from a,b where a.id=b.id')
else
exec ('insert ' + @tablename + ' a.name ,b.val from a,b where a.id=b.id')
exec ('select a.name ,b.val into ' + @tablename + ' from a,b where a.id=b.id')
else
exec ('insert ' + @tablename + ' select a.name ,b.val from a,b where a.id=b.id')