Prev: Sql Server express 2005 trying to install BIDS
Next: xp_sqlmaint
From: aspfun via SQLMonster.com on 25 Jan 2010 10:44
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

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201001/1

From: Russell Fields on 25 Jan 2010 11:15
You don't "need" them, since you can get working code without them. (You
might actually have these as your standard connection settings.) However,
these are good settings to have on when you create a procedure and having
them in the script means that it will correct any connection setting that
might be different.

FWIW,
RLF

"aspfun via SQLMonster.com" <u53138(a)uwe> wrote in message
news:a2a4f8c15cf53(a)uwe...
> 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
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201001/1
>


 | 
Pages: 1
Prev: Sql Server express 2005 trying to install BIDS
Next: xp_sqlmaint