May 21, 2009 at 3:18 am
Hi ,
I have some sql files which out of them one will create DB,tables and other will insert data into those tables and other will create proc's ......... like this . Is ther any way to run all these files from a proc to finish my DB creation.
Thnaks in advance for any solution.
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
May 21, 2009 at 3:43 am
copy all the information into one single file and compile in your database.
May 21, 2009 at 4:00 am
but i want it as a reusable component so that i can run when ever i want
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
May 21, 2009 at 4:05 am
Try creating a SP per component
ie
usp_CreateDB
usp_CreateSchema
usp_GenerateData
etc etc
Then within one file exec each of the SPs.
May 21, 2009 at 10:54 am
But how can i run a script in .sql file in proc, becuase i want it in sql file only (for me no other option)
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
May 21, 2009 at 12:06 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply