dynamic sql

 
if exists (select name from sysobjects where name = 'pr_testInsert')
 drop procedure pr_testInsert
go
CREATE Procedure pr_testInsert
 @varDtaCtlID as int,
 @varDtaPosID as int,
 @varDtaVersionID as int,
 @varDtaValue as nvarchar(4000)
 
AS

declare @sql as nvarchar(4000)
set @sql ='
   insert into tblData_21(dtaCtlID,dtaPosID,dtaVersionID,dtaValue  )
   VALUES('+cast(@varDtaCtlID as nvarchar(4000))+','+cast(@varDtaPosID as nvarchar(4000))+','+cast(@varDtaVersionID as nvarchar(4000))+','+cast(@varDtaValue as nvarchar(4000))+')
   '
EXEC sp_executesql @sql 
go