Which command executes the contents of a specified file?

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 6054
Answer:

START or @

 @ pathname
It will run a SQL Script.

Example:-
@Script1.sql parameter1 parameter2 parameter3


In the Script we can refer to the parameters as &1, &2, and &3.

Similarly @@ pathname will able to run a nested SQL Script.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Webmaster on: 1/21/2010
Could you please provide more description of the answer? One word answer is not enough.

Login to post response