Alter table without destroy variable

[chaoma]

I have query like:

Declare @count int
set @count=(select count(*) from table)

Alter table table
Add column1 int

Update table
Set column1=123

When I try to run this query, it complains that column1 does not exist. I can add a “GO” statement after

Alter table table
Add column1 int
GO

, but @count will be destroy.

Is there a way to resolve this problem?

Any help is very much appreciate.

Chaoma.

 

[SQLDenis]

Alter table table
Add column1 int

Declare @count int
set @count=(select count(*) from table)

Update table
Set column1=123

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[jbenson001]

How about trying this: Do your alter table first, then do the Count(*)?


Jim

 

[rac2]

Store @count in a table.