Take Rows orignal values after update

CREATE TABLE testOutPutClause
(id INT IDENTITY (1,1)
,Name VARCHAR(MAX)
,ModifiedBy INT
,Modifiedon DATETIME
)
INSERT INTO testOutPutClause VALUES('A',1, GETDATE())
INSERT INTO testOutPutClause VALUES('B',1, GETDATE())
INSERT INTO testOutPutClause VALUES('C',1, GETDATE())
INSERT INTO testOutPutClause VALUES('D',1, GETDATE())
INSERT INTO testOutPutClause VALUES('E',1, GETDATE())
DECLARE @tmpTable TABLE(
id INT
,Name VARCHAR(MAX)
,ModifiedOn DATETIME
,ModifiedBy INT
)
UPDATE testOutPutClause
SET Name=Name+'U'
,ModifiedBy = 1 + 10
OUTPUT
deleted.id
,Deleted.Name
,Deleted.Modifiedon
,Deleted.ModifiedBy
 INTO @tmpTable

 SELECT * FROM testOutPutClause

  SELECT * FROM @tmpTable
 
  DROP TABLE testOutPutClause

Rest Identity column

DBCC CHECKIDENT('tablename', RESEED)

Dynamic script for add columns

DECLARE @TableNameContainer TABLE
(
id INT IDENTITY(1,1)
,tableName VARCHAR(MAX)

)
DECLARE @RowCount INT, @index INT = 1;
INSERT INTO @TableNameContainer
SELECT name FROM sys.tables t2 WHERE
t2.name NOT IN ('Table1','Table2')-- list of table where you did not want to add
SELECT @RowCount = COUNT(*) FROM @TableNameContainer
WHILE (@index <= @RowCount)
BEGIN
DECLARE @tableName NVARCHAR(MAX) =(SELECT tableName FROM @TableNameContainer WHERE id= @index )
DECLARE @dynamicAlter NVARCHAR(MAX) =
'IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''CreatedBy'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [CreatedBy] [int] NULL END

IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''CreatedDate'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [CreatedDate] [datetime]  NULL  END

IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''ModifiedBy'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [ModifiedBy] [int] NULL  END

IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''ModifiedBy'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [ModifiedDate] [datetime] NULL  END

IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''IsDeleted'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [IsDeleted] [bit] NULL  END

IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''DeletedBy'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [DeletedBy] [int] NULL  END
     
IF NOT EXISTS (SELECT * FROM   sys.columns  WHERE  object_id = OBJECT_ID(N''[dbo].['+@tableName+']'') AND name = ''DeletedBy'')
BEGIN ALTER TABLE ['+@tableName+'] ADD [DeletedDate] [datetime] NULL  END    
'
EXECUTE sp_executesql @dynamicAlter
SET @index = @index + 1;
END-- OF WHILE

CPT vs HCPCS

CPT is a code set to describe medical, surgical ,and diagnostic services; HCPCS are codes based on the CPT to provide standardized coding when healthcare is delivered.

2. CPT is largely private, as the AMA has copyright ownership and does not wish to give the codes freely; according the Health Insurance Portability and Accountability Act of 1996, everyone must have access to HCPCS codes.

3. DRG codes are separate from HCPCS and CPT.Codes. DRG related to secondary diagnosis and primary diagnosis.