[dba-SQLServer] SQL in SP failing

Mark A Matte markamatte at hotmail.com
Thu Nov 30 13:13:44 CST 2006

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. 

More information about the dba-SQLServer mailing list