[dba-SQLServer] SQL in SP failing

Missed this earlier. The double quotes are your problem. 
 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: Mark A Matte <markamatte at hotmail.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Thursday, November 30, 2006 2:13:44 PM
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