[dba-SQLServer] SQL in SP failing

Wouldn't that make it think TEST was a column name...when I want it to be 
the value in each row?

Thanks,

Mark A. Matte


>From: "Eric Barro" <ebarro at verizon.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] SQL in SP failing
>Date: Thu, 30 Nov 2006 11:40:25 -0800
>
>Enclose test in brackets like this
>
>[test]
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A
>Matte
>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.
>
>Thanks,
>
>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.
> >
> >Debbie
> >
> >-----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.
> >
> >Thanks,
> >
> >Mark A. Matte
> >
> >_________________________________________________________________
> >Get the latest Windows Live Messenger 8.1 Beta version. Join now.
> >http://ideas.live.com
> >
> >- 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
>information.
> >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
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
> >
>
>_________________________________________________________________
>Stay up-to-date with your friends through the Windows Live Spaces friends
>list.
>http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spa
>ces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk
>
>
>--
>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
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Fixing up the home? Live Search can help 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG