Re: OPTIMIZER LOCK HINTS
From: Sa (ksadf_at_sdkaew.org)
Date: 01/11/05
- Next message: Gopinath Rajee: "Re: OPTIMIZER LOCK HINTS"
- Previous message: John Kane: "Re: fulltextindex"
- In reply to: Sa: "OPTIMIZER LOCK HINTS"
- Next in thread: Gopinath Rajee: "Re: OPTIMIZER LOCK HINTS"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 14:42:23 +0800
Sorry, I make a stupid mistake.
I rewrite to:
INSERT INTO ACCOUNT
(ACCOUNTID, ACCOUNT, MAINPHONE, FAX)
SELECT ACCOUNTID, ACCOUNT, MAINPHONE, FAX
FROM ACCOUNT_TEMP
SET @ins_error = @@ERROR
Then this error is got.
"Sa" <ksadf@sdkaew.org> wrote in message
news:%23vV8rT69EHA.3336@TK2MSFTNGP11.phx.gbl...
> Hello,
>
> I am writing a Stored Procedure. In the middle of the stored procedure, I
> have the following code:
>
> :
> :
> BEGIN TRAN dataMigration
>
> -- Insert records to the destination table
> INSERT ACCOUNT
> WITH (ACCOUNTID, ACCOUNT, MAINPHONE, FAX)
> VALUES (SELECT ACCOUNTID, ACCOUNT, MAINPHONE, FAX
> FROM ACCOUNT_TEMP)
> SET @ins_error = @@ERROR
> :
> :
>
> SQL Query Analyzer notified me that I have error for the line of "WITH
> (ACCOUNTID,.....)":
> 'ACCOUNTID' is not a recognized OPTIMIZER LOCK HINTS option.
>
> May I know the meaning of this message? How do I solve this problem?
>
> Thanks a lot.
>
> Sammy
>
>
- Next message: Gopinath Rajee: "Re: OPTIMIZER LOCK HINTS"
- Previous message: John Kane: "Re: fulltextindex"
- In reply to: Sa: "OPTIMIZER LOCK HINTS"
- Next in thread: Gopinath Rajee: "Re: OPTIMIZER LOCK HINTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
