@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"
Showing posts with label sqlcmd. Show all posts
Showing posts with label sqlcmd. Show all posts
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"
Subscribe to:
Posts (Atom)
