Stored procedures
From Species File Help
(Difference between revisions)
m |
m (Maehr moved page Debugging Stored Procedures to Stored procedures: Made into less specific page since no general description exists.) |
||
(One intermediate revision by one user not shown) | |||
Line 15: | Line 15: | ||
SELECT 'Return Value' = @return_value | SELECT 'Return Value' = @return_value | ||
GO | GO | ||
+ | |||
+ | [[Category:Developers]] |
Latest revision as of 18:00, 15 February 2013
- Stored procedures are kept in source control, and normally published to the database during builds
- To debug a stored procedure against the database
- Open SSMS, find the database containing the SP, and navigate to 'programmability, you'll find a list of SPs
- Right click, choose "Modify" or Script to -> Alter, you'll get the code in a new query window
- To execute the SP in SSMS right click, chose "Execute", you'll get a popup that will allow you to parameterize the SP, it will then generate *and execute* something like the following (this can be used subsequently to step through the SP):
USE [SFdbPractice] GO DECLARE @return_value int EXEC @return_value = [dbo].[spTestSpecimenLocNotInDist] @blnFix = 0, @intFileID = 1, @intFileUserID = 11 SELECT 'Return Value' = @return_value GO