Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Execute stored procedure from batch file

Tags:

sql-server

stored-procedures

batch-file

How would you execute a stored procedure in SQL Server (using windows authentication) from a batch file?

like image 413
Nitrodbz Avatar asked Oct 19 '12 18:10

Nitrodbz

1 Answers

If you are using Sql Server 2005+, you can use sqlcmd utility.

Example:

sqlcmd -Q "exec storedProcName" -S YourServer -d YourDatabase -o C:\yourOutput.txt

like image 51
dugas Avatar answered Oct 10 '22 05:10

dugas
Sign in to Comment

Related questions

ORDER BY with a UNION of disparate datasets (T-SQL)
Sql Server Service Broker: How to structure Conversations for a simple queue scenario?
SQL Server Always Encrypted with .NET Core not compatible
View is not schema bound?
Conditional SQL ORDER BY ASC/DESC for alpha columns
filtering inside COUNT in sql server [duplicate]
Fake a long running SQL statement
MSSQL: Disable triggers for one INSERT
Integrated Windows Authentication with IIS, Firefox and SQL Server
Tool to export result set from SQL to Insert statements?
Is there a way to convert a non-clustered index on a Primary Key to a clustered one? (SQL Server 2008)
Reuse identity value after deleting rows
Why can't I reorder my SQL Server columns?
Connection between MSSQL and PHP 5.3.5 on IIS is not working
Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
How to show CLOB type in a SELECT in SQL Server?
Does MS-SQL support in-memory tables?
What are good problems to solve using CLR stored procs?
Is SQL Server 'MONEY' data type a decimal floating point or binary floating point?
Need to generate n rows based on a value in a column

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!