Link to home
Create AccountLog in
Avatar of csePixelated
csePixelatedFlag for United States of America

asked on

sql query syntax issues

would like to find the correct syntax for the following query's

UPDATE    DAAutoReports
SET              NextRun = [2012-11-08 00:00:00.000]
WHERE     (NextRun = [2012-11-09 00:00:00.000])

keeps kicking back either "invalid column name 2012-11-08 00:00:00.000" or "incorrect syntax near 00"

AND

UPDATE    DAAutoReports
SET              NextRun = [2012-11-08 00:00:00.000]
WHERE     (Frequency = 0)

keeps kicking back either "invalid column name"
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account