How to execute script file in sql server?

Question

0.00/5 (No votes)

See more:

hello expert

I don't know the concept of execution of script file
please send In detail how to execute script file in sql server

thank & regards
vinay gouda

Posted 8-Nov-11 0:00am

vinayfirstblock

Updated 8-Nov-11 1:33am

Amir Mahfoozi

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

P.Salini · Answer 1 · 2011-11-08T00:04:00

Solution 3

Check this

I did not get your question exactly.

i hope you are looking for this

http://msdn.microsoft.com/en-us/library/ms170572.aspx[^]

Posted 8-Nov-11 0:04am

P.Salini

sravani.v · Answer 2 · 2011-11-08T00:03:00

Solution 1

Refer these:

http://www.cyberciti.biz/faq/execute-sql-script-file-on-microsoft-sql-database/[^]

http://www.ehow.com/how_6317287_execute-microsoft-sql-server-2005.html[^]

Posted 8-Nov-11 0:03am

sravani.v

Updated 8-Nov-11 0:06am

v2

Mehdi Gholam · Answer 3 · 2011-11-08T00:04:00

Solution 2

Read this:

Running Transact-SQL Script Files Using osql[^]

Posted 8-Nov-11 0:04am

Mehdi Gholam

Amir Mahfoozi · Answer 4 · 2011-11-08T02:01:00

To execute scripts in Sql Server Management Studio : first connect to a server then load a script file or write your own then press F5 to execute it.

If you want to execute a script from command prompt then consider sqlcmd command.

Sqlcmd -S servername\SQLEXPRESS -i test.sql

read its parameters info at :
http://msdn.microsoft.com/en-us/library/ms165702.aspx[^]

Ans if you want execute a script in your SQLs then consider using sp_exectesql
read more at :
http://msdn.microsoft.com/en-us/library/ms188001.aspx[^]