Test SQL query/stored procedure from the command line...

by Miro 21. September 2008 17:29

...using the sqlcmd utility

sqlcmd -S . -d MyDatabaseName -U userName -P pazzword -Q "EXEC[dbo].[spGiveMeSomeData] @Par1 = 5, @Par2 = NULL, @Par3 = N'AnotherString'"

Tags:

List all stored procedures using a specific search criteriaGood for creating the update scripts select '/************' + OBJECT_NAME(id) + '***...Search all user stored procedures for a specific pattern The following script returns the contents of the stored procedures which contain the specific patt...SQL SnippetsCalculate length of the text field use DATALENGTH(fieldName) CTE (Common Table Expression) ...

Related posts