Returning value from sp_executesql | Ashish Gupta

Returning value from sp_executesql

USE Northwind
DECLARE @Count int
execute sp_executesql
N’select @Count = COUNT(*) from Northwind.dbo.Orders’,
N’@Count int OUT’, @Count OUT
SELECT @Count

This entry was posted on March 5, 2007, 6:52 pm and is filed under Sql Server. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

Comments (0)

Leave a comment

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Random Thoughts

The World as I see it

Enterprise Developers Guild

Simple Programmer

Making The Complex Simple

Ionic Solutions

Random thoughts on software construction, design patterns and optimization.

Defunct – go to codeblog.jonskeet.uk – Jon Skeet: Coding Blog

Scott Hanselman's Blog

A tragic's view from the cricket hinterlands

<span>%d</span> bloggers like this: