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:

Truncate SQL Server transaction log Sometimes you can't shrink the transaction log using the SSMS utility. Try truncating the log ...Return a random number from 1 to 10000 in SQL Server DECLARE @Result int SET @Result = CONVERT(int, 1 + 10000*RAND(CHECKSUM(NEWID()))) RETURN...List all stored procedures using a specific search criteriaGood for creating the update scripts select '/************' + OBJECT_NAME(id) + '***...

Related posts