SQL Server 2012 Syntax Error

[pat718]

I am trying to alter a table to add a column and than update that column with integer values from 0 to 5. I keep getting a syntax error near my WHERE clause. Here's is what I wrote:

alter table aggregator_table
add access_level integer
WHERE access_level == 0 and access_level<=5

Can anyone help me? Thanks.

 

[SQLBill]

First of all, you can't add a column and update in the alter statement. You need to add the column (using the alter table statement) and then do an update. Second, == isn't Microsoft SQL Server syntax.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875