Is there a function in T-SQL similar to Sybase's "READ" where an SQL Batch file is read and the statments are executed from the file? Right now I have all my database scripts hard coded in a VB application. I would like to remove it and just read a text file instead. PLEASE HELP


For example "READ c:myFile.sql"

contents of myFile.sql:


CREATE DATABASE .....

CREATE Stored Procedure .....