Do I need set all and then go in a new SP? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Do I need set all and then go in a new SP?

Author

Topic

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2010-01-25 : 10:43:17

Sentences below are from the new store procedure template.
Do I need all of them?

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-25 : 10:47:13

generally they're generated as default options. you can change them if you want.

X002548
Not Just a Number

15586 Posts

Posted - 2010-01-25 : 12:56:22

yes, only if you want them ON...as mentioned, they are the default

BUT

If they are off when you compile it..I Think they will be OFF

Gotta check that

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Kristen
Test

22859 Posts

Posted - 2010-01-25 : 14:37:49

I could put SET NOCOUNT ON outside the SProc create and that would be the State when it runs?

That would save having SET NOCOUNT ON within the Sproc.

"Gotta check that"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources