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 |
|
deepa
Starting Member
17 Posts |
 Posted - 2003-01-03 : 02:36:27
|
| I have the following syntax. I get an error message as Incorrect syntax near query out Can anyone help me correct thisbcp "select * from bisdb.dbo.bis where month(inv_date) = 05 ANDyear(inv_date) = 2002" queryout"bis.txt" -c -t"|" -Smatsya-sql.india.hp.com -Ucdb -PcdbprojThanks in advanceDeepaDeepa |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-01-03 : 06:40:27
|
| Just a thought - change select to following:"select * from [bisdb].[dbo].[bis] where month(inv_date) = 5 AND year(inv_date) = 2002"*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Incorrect Syntax - Can anyone help me out