InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 10:47:51 GMT20http://www.sqlservercentral.com/Forums/Topic887195-392-1.aspx[quote][b]The Dixie Flatline (3/23/2010)[/b][hr]True, but then you create headaches for the poor, struggling UI developer who has to learn how to handle two different types of output from a single procedure. ;-)[/quote]In my experience, UI developers are happier* to learn about OUTPUT parameters than to use MARS.Turning a parameter into an OUTPUT parameter generally involves just specifying its direction in an existing .NET statement.[hr][i]* = also, if they want to use my database, they will do it my way :laugh: :laugh: :laugh:[/i]Tue, 23 Mar 2010 07:35:26 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspxTrue, but then you create headaches for the poor, struggling UI developer who has to learn how to handle two different types of output from a single procedure. ;-)Tue, 23 Mar 2010 06:44:21 GMTThe Dixie Flatlinehttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspx[quote][b]WangcChiKaBastar (3/22/2010)[/b][hr]I have to write a sp that would give two data sets...[/quote]It is usually more efficient to just return one data set, and return the row count in an output parameter.Tue, 23 Mar 2010 04:16:25 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspxNice sample and explanation Dave and Bob.Mon, 22 Mar 2010 13:19:37 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspxDave's right. Here's a good practice tip: @@ROWCOUNT changes with each new SET or SELECT, so if you want to hold on to the value for a while, be sure to store it in the variable of your choice.[code]-- always returns a @@ROWCOUNT of 1, because of the SET statementdeclare @DoNothing intselect name from sys.databases SET @DoNothing = 1select @@ROWCOUNT as rowsReturnedgo-- saves the rowcount in @RC for later referencedeclare @rc intdeclare @DoNothing intselect name from sys.databasesSET @rc = @@ROWCOUNT -- save for later set @DoNothing = 1select @rc as rowsReturned[/code]Mon, 22 Mar 2010 12:13:10 GMTThe Dixie Flatlinehttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspxhave a look at @@rowcount in BOL (Books On Line) [url]http://msdn.microsoft.com/en-us/library/ms187316.aspx[/url]Mon, 22 Mar 2010 02:14:45 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic887195-392-1.aspxI have to write a sp that would give two data sets one with the coumns (metadata) like firstname, lastname, address, phonenumberand then second result set would return just the count of the rowscount(*) of the above selectplease adviseMon, 22 Mar 2010 01:36:22 GMTWangcChiKaBastar