This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE dbo.Emp | |
WHERE FirstName = 'Joey' | |
AND LastName = 'Tribbiani' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * | |
, CHANGE_TRACKING_IS_COLUMN_IN_MASK (COLUMNPROPERTY(OBJECT_ID('dbo.Emp'), 'LastName', 'ColumnId'), ct.SYS_CHANGE_COLUMNS) AS MiddleName_Changed | |
FROM CHANGETABLE(CHANGES dbo.Emp, @ver) AS ct |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE dbo.Emp | |
SET MiddleName = 'Muriel' | |
WHERE FirstName = 'Chandler' AND LastName = 'Bing' | |
UPDATE dbo.Emp | |
SET LastName = 'Bing' | |
WHERE FirstName = 'Monica' AND LastName = 'Geller' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET @ver = CHANGE_TRACKING_CURRENT_VERSION() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * | |
FROM CHANGETABLE(CHANGES dbo.Emp, @ver) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT dbo.Emp VALUES ('Joey' ,NULL ,'Tribbiani') | |
INSERT dbo.Emp VALUES ('Chandler' ,NULL, 'Bing') | |
INSERT dbo.Emp VALUES ('Ross',NULL,'Geller') | |
INSERT dbo.Emp VALUES ('Monica',NULL,'Geller') | |
INSERT dbo.Emp VALUES ('Rachel',NULL,'Green') | |
INSERT dbo.Emp VALUES ('Phoebe',NULL,'Buffay') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT CHANGE_TRACKING_CURRENT_VERSION() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE [dbo].[Emp] | |
ENABLE change_tracking WITH (track_columns_updated = ON) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE Emp | |
( | |
ID INT PRIMARY KEY IDENTITY(1, 1), | |
FirstName VARCHAR(100), | |
MiddleName VARCHAR(100), | |
LastName VARCHAR(100) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public override void CreateNewOutputRows() | |
{ | |
// All I need to do in this script component is to cast the object variable to a DataTable | |
DataTable dt = (DataTable)Variables.vResults; | |
// The DataTable is now ready to use! No more recordset quirks. | |
foreach (DataRow dr in dt.Rows) | |
{ | |
/* |