[dba-SQLServer] SQL in SP failing

Eric Barro ebarro at verizon.net
Thu Nov 30 13:40:25 CST 2006

Enclose test in brackets like this


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A
Sent: Thursday, November 30, 2006 11:26 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL in SP failing

If I use single quotes...SQL says it is a syntax error before I even run
it...won't even let me save it that way.


Mark A. Matte

>From: "Elam, Debbie" <DElam at jenkens.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "'dba-sqlserver at databaseadvisors.com'" 
><dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] SQL in SP failing
>Date: Thu, 30 Nov 2006 13:23:00 -0600
>Use single quotes around test.  Double quotes will cause problems.
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Thursday, November 30, 2006 1:14 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] SQL in SP failing
>Hello All,
>Any idea why the following SQL will fail in an SP?
>'insert into tblBrita_ID(case_id,Criteria) SELECT case_id, "test" As 
>Criteria FROM tblCase where case_id=1'
>The error is "Invalid column name 'test'."  It doesn't always 
>fail...normally 'test' is a parameter passed to the SP...I have 
>modified it to the above for demo purposes...but using just the word 
>'test' as above still gives the same error.
>Mark A. Matte
>Get the latest Windows Live Messenger 8.1 Beta version. Join now.
>- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) 
>subject to the Attorney-Client Privilege, (2) an attorney work product, 
>or (3) strictly confidential. If you are not the intended recipient of 
>this message, you may not disclose, print, copy or disseminate this
>If you have received this in error, please reply and notify the sender
>(only) and delete the message. Unauthorized interception of this e-mail 
>is a violation of federal criminal law.
>This communication does not reflect an intention by the sender or the 
>sender's client or principal to conduct a transaction or make any 
>agreement by electronic means.  Nothing contained in this message or in 
>any attachment shall satisfy the requirements for a writing, and 
>nothing contained herein shall constitute a contract or electronic 
>signature under the Electronic Signatures in Global and National 
>Commerce Act, any version of the Uniform Electronic Transactions Act or 
>any other statute governing electronic transactions.
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

Stay up-to-date with your friends through the Windows Live Spaces friends

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.2/559 - Release Date: 11/30/2006

More information about the dba-SQLServer mailing list