Create and Update new field SQL 2005 1

[Rob7412]

I have a script that adds a bit field to an existing table, Default value of 0. I would like the same script to also go in and update the field to a bit value of 1 after creating it but the server keeps giving and error saying field does not exist. If i refresh the db the field is there but the script cannot see it. any idea on how to handle this? Thanks for any advice.

If Knowledge were power I would be a AAA Battery!

 

[SQLDenis]

run this

create table a(id int)
go
insert a values(1)
go
select 'before addition of column',* from  a
go
alter table a add Col int default 0
go
select 'before update',* from  a
update a set col = 666
go
select 'after update',* from  a
go
drop table a
go

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[Rob7412]

Fantastic Thanks

If Knowledge were power I would be a AAA Battery!