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 |
|
onkabetse
Starting Member
5 Posts |
 Posted - 2011-04-20 : 13:46:13
|
| I am working on a school project on sql server 2005. I then have to validate orderdate column to accept a date which is not greater than current date. I tried to use the following syntax but did not work;;orderdate<date()orderdate<Now()orderdate<=Date()Help me on how I can validate the field.. |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-20 : 13:50:13
|
| To get the current date use GETDATE() instead of Now().Hey, it compiles. |
 |
|
|
|
|
|
SQL Sever 2005