Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harisgtj
Starting Member
1 Post |
 Posted - 2011-08-02 : 07:06:29
|
| Im trying what seems to be a simple query, but Im getting an invalid column name.in sql server express 2008 the query is select product_id, product_name from product where product_name like 'Microsoft%'which will return all rows with Microsoft in the product name ie office, server etc.I tried this using in python using pymssql using the query"select product_name, product_id from product where product_name like 'Microsoft'"this returns an invalid column name Microsoft error, if I try using the % wildcard syntax that also raises errorI understand I may be calling the query in the wrong order but I cant see how to solve itMuch Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-02 : 07:12:53
|
| Check how you can pass constant values in python. it seems to be python error and has no relation to sql------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
like invalid column name