RE: pb with "QUOTED_IDENTIFIER"

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 11/22/04 

Date: Sun, 21 Nov 2004 16:35:15 -0800

Why are you setting quoted identifiers on? You don't seem to need it.
Same goes for most of the set statements.

"philned" wrote:

> hello,
>
> I've a problem with a trigger :
> this trigger update a file with an index field but it's return an error
> : UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
> parameters
>
> for information, this is my trigger :
>
> CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
> SET NOCOUNT ON
> set arithabort on
> set concat_null_yields_null on
> set quoted_identifier on
> set ansi_nulls on
> set ansi_padding on
> set ansi_warnings on
> set numeric_roundabort off
> declare @code varchar(17)
> select @code=ar_ref from inserted
> begin
> */ replace if reference = 0 */
> if @code='0'
> begin
>
> update f_article set ar_ref='test' from f_article join
> inserted on f_article.cbmarq=inserted.cbmarq
> end
> end
>
>
> if you ave an idea...
> thanks
> philned
>

Relevant Pages

  • Help:Error 7405 - Problem accessing linked server in trigger
    ... I have written an insert trigger In SQL server 2K that is supposed to ... of the select query. ... Are these two SET statements the only suspect that caused my access ...
    (microsoft.public.sqlserver.programming)
  • Re: Insert Trigger error
    ... Update & Set statements. ... > I'm hoping someone here can tell me what is wrong with this INSERT Trigger ... > nvarchar value 'UPDATE tblPhoneLog INNER JOIN TblPhone ON ...
    (microsoft.public.sqlserver.tools)
  • Re: Insert Trigger error
    ... Update & Set statements. ... > I'm hoping someone here can tell me what is wrong with this INSERT Trigger ... > nvarchar value 'UPDATE tblPhoneLog INNER JOIN TblPhone ON ...
    (microsoft.public.sqlserver.programming)
  • Re: DELETE failed because the following SET options have incorrect settings: QUOTED_IDENTIFIER
    ... i set on queryidentifier and ansi null on and then i created trigger ... And the cursor can be ... Please remove that cursor and take out those SET statements, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • pb with a trigger
    ... I've a problem with a trigger: ... this trigger update a file with an index field but it's return an error ... if you ave an idea... ...
    (microsoft.public.sqlserver.server)