When we add a column with default constraint will the Ct version changes or not
use prism
/* Creating a table*/
Create table dbo.Prismtest
(
Id int primary key identity(1,1),
[Name] Varchar(10))
alter table dbo.Prismtest add [Address2] varchar(100) default('abc') not null
select * from dbo.prismtest
insert into dbo.Prismtest ([Name]) values ('def' )
select ct.* FROM changetable(changes dbo.Prismtest,1 ) as ct
LEFT JOIN dbo.Prismtest a on a.id=ct.id -- 54067710 /Checking the data in CT table*/
select change_tracking_Current_version() -- 54067711
/* Here check the CT version is getting changed or not -- Important */
Alter table dbo.Prismtest
Enable change_tracking
WITH (TRACK_COLUMNS_UPDATED = OFF);
/* Creating a table*/
Create table dbo.Prismtest
(
Id int primary key identity(1,1),
[Name] Varchar(10))
alter table dbo.Prismtest add [Address2] varchar(100) default('abc') not null
select * from dbo.prismtest
insert into dbo.Prismtest ([Name]) values ('def' )
select ct.* FROM changetable(changes dbo.Prismtest,1 ) as ct
LEFT JOIN dbo.Prismtest a on a.id=ct.id -- 54067710 /Checking the data in CT table*/
select change_tracking_Current_version() -- 54067711
/* Here check the CT version is getting changed or not -- Important */
Alter table dbo.Prismtest
Enable change_tracking
WITH (TRACK_COLUMNS_UPDATED = OFF);
Comments
Post a Comment