ms-sql OUTPUT equivalent

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

ms-sql OUTPUT equivalent

Clark Allan
Is there an equivelent to the OUTPUT parameter in MS-SQL?
here is an example:
----------------------------------------
CREATE PROCEDURE GetPagedList
(
 @CurrentPage   tinyint,
 @PageSize   tinyint,
 @TotalRecords   int OUTPUT,
)
AS
Set NoCount On
-- ...some code here...

-- Return the total number of records available as an output parameter
Select @TotalRecords = Count(*) From tblemp

GO
---------------------------------------
I am using the Npgsql data provider in a .net app, and have noticed you can set the Parameter direction to be output
eg "NpgsqlParameter.Direction = ParameterDirection.Output"
Is this just a case of npgsql getting ahead of pg?

Thanks
Clark

Reply | Threaded
Open this post in threaded view
|

Re: ms-sql OUTPUT equivalent

Douglas McNaught
Clark Allan <[hidden email]> writes:

> Is there an equivelent to the OUTPUT parameter in MS-SQL?

Not in the current release, but the upcoming 8.1 release will have it.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq