Can I write multiple queries in Execute SQL Task Editor at a time
Can I write multiple queries in Execute SQL Task Editor at a time???
Can I write these two queries???
ALTER
Table [Islamabad_campus]. [dbo]. [BS_Students]
ADD Location
VARCHAR ( 10);
UPDATE
[Islamabad_campus]. [dbo]. [BS_Students]
SET
Location
= 'Islamabad' ;
mhassanshahbaz
November 25th, 2010 10:03am
Yes, you can.
Put a "GO" between both queries, otherwise you will get an error, because the new column is not known in the second query.
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 10:11am