I created an procedure which dynamically identifies table and insert the required values into the corresponding fields. Procedure goes like... ALTER PROCEDURE [dbo].[proc_formInsert] @mode varchar(1), @tableName nvarchar(50), @fields nvarchar(MAX), @strParam NVARCHAR(MAX), @delimit nvarchar(2), @formName nvarchar(20), @formTab nvarchar(5) AS DECLARE @SQL VARCHAR(MAX) IF @mode = 'I' BEGIN --SELECT @sql ='if OBJECTPROPERTY(object_id(''' + @tableName +'''), ''TableHasIdenti...