Execute stored procedure from cmd.exe?

Question

Is there anyway to run a stored proc from cmd.exe ?

p.s.
I know how to create exec file c# and to run it.

I'm asking without any code :

Just me and cmd.exe.

edit

me and cmd.exe : meaning I don't want to write any code. Internal SQL Server help exe files of sql is fine !

sorry for not clarifying this !

Answer 1

Try using the SQLCMD Utility :

An example:

sqlcmd -E -S server_name -d database_name -Q "EXEC schema.storedprocedure parameter01, parameter02"

If you'd like to explore other options I'd like to share this link:

Command Prompt Utilities: Applicable for SQL Server 2005

Answer 2

• For sql server 2005+ use its SQLCMD utility, as @Nonim answered
• for versions prior to 2005 use its OSQL utility, its usage is similar to SQLCMD

Wrap it into the .cmd file and you're in! No needs to write something, just click'n'go! 8-)