Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Nov 15, 2002

Testing the Output Values of a Stored Procedure


This tip is useful when debugging and testing complex stored procedures that have a lot of business logic. It helps to find out exactly what is being returned from a stored procedure.

Assume you have a stored procedure:
 
/****** Object:  Stored Procedure dbo.sp_DeleteBasketComponents   
Script
Date: 30/11/2000 10:40:23 AM ******/
CREATE PROCEDURE sp_test
(@m_BasketCode varchar(64),
@m_Dateout DateTime OUTPUT )
AS
--... Do something
-- Assign value to m_dateout for testing
Select @m_Dateout = "26-Apr-2002"
GO

Now, have SQL Query Analyzer perform the following:
 
Delcare @d Datetime
exec sp_test "FTSE",@d OUTPUT
Select @d

Select all 3 SQL statements and execute. The correct value is displayed.
Nirav Shah
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date