My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

Calling Stored Procedure From Command Prompt

Thursday, 11 August 2011




@ECHO OFF
set sqlserverinstance=192.168.1.2\sqlexpress
set serverusername=sa
set serverpassword=123
set DatabaseName=Madhan

Sqlcmd -S %sqlserverinstance% -U %serverusername% -P %serverpassword% -d %DatabaseName% -Q "exec SPNAME"

No comments:

Post a Comment

 

Blogger news

Blogroll

Most Reading

8.6/10