Friday, March 23, 2012

How to test SP in SQL Server Express?

How can I test a stored proc that is in my SQL Server Express 2005 database? I don't see anything in VS 2005 or a Query Analyzer in SSMS express. ThanksYou can do it in two ways in Management Studio Express:

1. Go to Programmability > Stored Procedures in Object Explorer and then right-click the name of the stored procedure you wish to execute and choose 'Execute Stored Procecure...'

2. In SQL Query window type 'EXEC nameofprocedure param1, param2' etc. (Replacing your real values, of course!)sql

No comments:

Post a Comment