Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Returning Data from Stored Proc Expand / Collapse
Author
Message
Posted Sunday, May 18, 2008 12:34 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Returning Data from Stored Proc
Post #502589
Posted Monday, May 19, 2008 9:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:22 PM
Points: 1,343, Visits: 789
Cursor datatype, huh? Does somebody have any sample code to demonstrate? I've never used it before...

Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)

Post #502895
Posted Tuesday, May 20, 2008 5:46 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:22 AM
Points: 1,755, Visits: 4,652
Todd Carrier (5/19/2008)
Cursor datatype, huh? Does somebody have any sample code to demonstrate? I've never used it before...

Microsoft does... http://msdn.microsoft.com/en-us/library/ms175498.aspx



Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.
Post #503516
Posted Wednesday, May 21, 2008 8:05 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
Good one.....


Post #504489
Posted Tuesday, May 27, 2008 6:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 12, 2014 12:57 PM
Points: 2,285, Visits: 4,225
IMOP, using the return code to contain data values is a new Worst Practice !

SQL = Scarcely Qualifies as a Language
Post #507342
Posted Thursday, June 12, 2008 1:57 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 12:00 PM
Points: 633, Visits: 81
Yes, you can use a return code to return data.
But just because you can, doesn't mean you should!

I agree that this is a new Worst Practice, and should at least have something in the answer describing it as such.
Post #516241
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse