By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I am currently reading Transact-SQL by Bennett McEwan. I was trying to do a query on the pubs test database...select "Hello, my name is ", fname from employee
No matter how I word the query it keeps bombing out and saying...Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'hello, my name is'.
Is the command structure for "Constant Strings" different for SQL 2000?
Let's say I have a table named "STAFF". One of the fields is "NAME". Now, if I have a staff name "Mohd Ja'far" then how can I retrieve this data using SQL. The query:SELECT * FROM STAFF WHERE NAME LIKE '%Ja'fa%'
is not working because the ' in the name.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.