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 |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-06-21 : 15:46:12
|
| Guys,My Query is SELECT * FROM tblbook WHERE InActive = 0 OR Inactive IS NULLI am getting the error incorrect Syntax at 'WHERE'also the whole query works fine in the Query Analyzer. But in the application it doesn't work.If i just use SELECT * FROM tblbook it works fine in the application. any ideas..?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-21 : 15:47:34
|
| If it works fine in Query Analyzer, then the problem isn't with your query or with SQL Server. You'll need to post your code in order for us to tell you where the problem in your application is.Tara Kizeraka tduggan |
 |
|
|
|
|
|
SQL Query Help