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.