var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SELECT * WHERE [date] > 100 days
for MS SQL 2000/2000, I need :
SELECT * FROM table1 WHERE table1.[date] > 100 days
how can i do that ?
thank you for helping
greater than 100 days?
that is an incomplete specification
please try to state in words what you want
UPDATE Users SET status = 3 WHERE (DATEDIFF(day, dInscript, GETDATE()) > 100)