Откройте свой Мир!

begin transaction
--Adding data from Persons table to @table
declare @table table(
ind int identity(1,1), UserId int,
FirstName nvarchar(50), LastName nvarchar(50),
Gender bit, CountryId int, CityId int, isNotifiedByEmail bit);
insert into @table
select UserId, FirstName, LastName,
Gender, CountryId, CityId, isNotifiedByEmail
from Persons;

--Adding new columns to Users table
alter table [dbo].[Users]
add [FirstName] nvarchar(50) COLLATE Cyrillic_General_CI_AS NULL,
[LastName] nvarchar(50) COLLATE Cyrillic_General_CI_AS NULL,
[Gender] bit NOT NULL DEFAULT ((0)),
[CountryId] int NOT NULL DEFAULT ((0)),
[CityId] int NOT NULL DEFAULT ((0)),
[isNotifiedByEmail] bit NULL DEFAULT ((1));

--Adding data to altered Users table from @table
--Update working by cycle
declare @from int, @to int, @userId int
declare @alterTable nvarchar(max);
declare @FirstName nvarchar(50),
@LastName nvarchar(50),
@Gender bit,
@CountryId int,
@CityId int,
@isNotifiedByEmail bit;
set @to = (select COUNT(*) from @table);
set @from=1;
declare @command nvarchar(max)

while (@from<=@to)
begin
set @UserId=(select UserId from @table as t where t.ind=@from)
set @FirstName=(select FirstName from @table as t where t.ind=@from)
set @LastName=(select LastName from @table as t where t.ind=@from)
set @Gender=(select Gender from @table as t where t.ind=@from)
set @CountryId=(select CountryId from @table as t where t.ind=@from)
set @CityId=(select CityId from @table as t where t.ind=@from)
set @isNotifiedByEmail=(select isNotifiedByEmail from @table as t where t.ind=@from)

--Здесь возникает ошибка! Говорит, что таких столбцов не существует. Пробовал через sp_executesql передать строку - все равно.
update [dbo].[Users]
set FirstName=@FirstName,
LastName=@LastName,
Gender=@Gender,
CountryId=@CountryId,
CityId=@CityId,
isNotifiedByEmail=@isNotifiedByEmail
where @UserId=Users.UserId
set @from=@from+1;
end

--Adding foreign keys to new columns
alter table [dbo].[Users] with check add constraint [FK_Users_Cities] foreign key([CityId])
references [dbo].[Cities] ([CityId])
alter table [dbo].[Users] check constraint [FK_Users_Cities]

alter table [dbo].[Users] with check add constraint [FK_Users_Countries] foreign key([CountryId])
references [dbo].[Countries] ([CountryId])
alter table [dbo].[Users] check constraint [FK_Users_Countries]

--deleting constraints and columns from Persons table
alter table [dbo].[Persons] drop constraint [FK_Persons_Cities]
alter table [dbo].[Persons] drop constraint [FK_Persons_Countries]
alter table [dbo].[Persons]
drop column FirstName, LastName, Gender, CountryId, CityId, isNotifiedByEmail

if @@trancount>0 commit transaction
else
rollback

--Checking =)
select * from Users