F fwcy Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-12 #1 我想在MS SQL 7.0的存储过程中写上,当服务器的日期大于某一日期存储过程就不执行! 比如:if GETDATE>'2003-01-01' exit{这两条语句通不过} 怎么写呢?
A am2001 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-12 #2 if getdate() > 某一日期 return
A antic_ant Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-12 #4 if CONVERT(varchar(10), GETDATE(),126)>'2003-01-01' return