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 |
|
fishysushii
Starting Member
1 Post |
 Posted - 2012-04-22 : 15:03:09
|
| Two questions:I'm running SQL off of XAMPP, using the command source /path/test.sqlHow would I pass in command arguments? I know that to use the arguments within the script i use #1, #2, etc, but how do the arguments get passed in?My second question is, what is wrong with this syntax? I keep getting error messages but can't figure out whats wrong. SELECT * FROM tWHERE #1>start AND #2 <endOR #1<start AND #2 BETWEEN start and endOR #1 BETWEEN start and end AND #2>endOR #1<start AND #2>end; |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-22 : 19:27:16
|
| Is your back end using SQL Server or MySql? If it is MySql, post your question to a MySql forum; SQLTeam is all about Microsoft SQL server, so any experise in XAMPP or MySql is likely to be very rare.Even better perhaps, post the question to a XAMPP support forum. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-22 : 21:29:17
|
| one small probelm though unrelated is you've to wrap the different conditions separated by OR within braces () else OR will cause all other conditions to be bypassed------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL syntax/parameters