Welcome to ChaudharyTechBlog

Create FUNCTION [dbo].[fnSplitString] (     @string NVARCHAR(MAX),     @delimiter CHAR(1) ) /* select SplitData from fnSplitString('1,2,3,4,5,6',',') */ RETURNS @output TABLE(splitdata NVARCHAR(MAX) ) AS BEGIN     DECLARE @start INT, @end INT     SELECT @start = 1, @end = CHARINDEX(@delimiter, @string)     WHILE @start < LEN(@string) + 1 BEGIN         IF @end = 0               SET @end = LEN(@string) + 1                 INSERT INTO @output (splitdata)           VALUES(SUBSTRING(@string, @start, @end - @start))         SET @start = @end + 1         SET @end = CHARINDEX(@delimiter, @string, @start)             END     RETURN END

Create Proc sp_CreateAuditTable @table_name SYSNAME As --Declare @table_name SYSNAME --SELECT @table_name = 'dbo.Dtl_Tables' DECLARE       @object_name SYSNAME     , @object_id INT SELECT       @object_name = '[' + s.name + '].[' + o.name + '_A]'     , @object_id = o.[object_id] FROM sys.objects o WITH (NOWAIT) JOIN sys.schemas s WITH (NOWAIT) ON o.[schema_id] = s.[schema_id] WHERE s.name + '.' + o.name = @table_name     AND o.[type] = 'U'     AND o.is_ms_shipped = 0 Print @object_id DECLARE @SQL NVARCHAR(MAX) = '' ;WITH index_column AS (     SELECT           ic.[object_id]         , ic.index_id         , ic.is_descending_key         , ic.is_included_column         , c.name     FROM sys.index_columns ic WITH (NOWAIT)     JOIN sys.columns c WITH (NOWAIT)...

Create Proc sp_CreateAuditTable @table_name SYSNAME As --Declare @table_name SYSNAME --SELECT @table_name = 'dbo.Dtl_Recipe_Items' DECLARE       @object_name SYSNAME     , @object_id INT SELECT       @object_name = '[' + s.name + '].[' + o.name + '_A]'     , @object_id = o.[object_id] FROM sys.objects o WITH (NOWAIT) JOIN sys.schemas s WITH (NOWAIT) ON o.[schema_id] = s.[schema_id] WHERE s.name + '.' + o.name = @table_name     AND o.[type] = 'U'     AND o.is_ms_shipped = 0 Print @object_id DECLARE @SQL NVARCHAR(MAX) = '' ;WITH index_column AS (     SELECT           ic.[object_id]         , ic.index_id         , ic.is_descending_key         , ic.is_included_column         , c.name     FROM sys.index_columns ic WITH (NOWAIT)     JOIN sys.columns c WITH (...