Insert data table data in Table

create procedure Sp_TableDataInsert
@TempTable TypeTable READONLY
As
Begin
SET IDENTITY_INSERT TableName ON
insert into Table (Column1, Column2 , Column3 , Column4 )
select Column1 , Column2 , Column3 , Column4 from @ TempTable
SET IDENTITY_INSERT TableName OFF
End

Leave a Reply

Your email address will not be published. Required fields are marked *