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

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 Twitter account. ( Log Out / Change )

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

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

Cancel

Connecting to %s

Ashish Gupta

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.

read this

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

Coding Horror

Scott Hanselman's Blog

Long (Way) Off

A tragic's view from the cricket hinterlands

%d bloggers like this:

Ashish Gupta