Created
March 4, 2020 15:04
-
-
Save Lucas2k/04e5d3319f2b02ac4b2d6d768762f7ad to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER PROCEDURE sp_generate_insertscripts | |
( | |
@TABLE_NAME VARCHAR(MAX), | |
@FILTER_CONDITION VARCHAR(MAX)='' | |
) | |
AS | |
BEGIN | |
SET NOCOUNT ON | |
DECLARE @CSV_COLUMN VARCHAR(MAX), | |
@QUOTED_DATA VARCHAR(MAX), | |
@TEXT VARCHAR(MAX) | |
SELECT @CSV_COLUMN=STUFF | |
( | |
( | |
SELECT ',['+ NAME +']' FROM sys.all_columns | |
WHERE OBJECT_ID=OBJECT_ID(@TABLE_NAME) AND | |
is_identity!=1 FOR XML PATH('') | |
),1,1,'' | |
) | |
SELECT @QUOTED_DATA=STUFF | |
( | |
( | |
SELECT ' ISNULL(QUOTENAME('+NAME+','+QUOTENAME('''','''''')+'),'+'''NULL'''+')+'','''+'+' FROM sys.all_columns | |
WHERE OBJECT_ID=OBJECT_ID(@TABLE_NAME) AND | |
is_identity!=1 FOR XML PATH('') | |
),1,1,'' | |
) | |
SELECT @TEXT='SELECT ''INSERT INTO '+@TABLE_NAME+'('+@CSV_COLUMN+')VALUES('''+'+'+SUBSTRING(@QUOTED_DATA,1,LEN(@QUOTED_DATA)-5)+'+'+''')'''+' Insert_Scripts FROM '+@TABLE_NAME + @FILTER_CONDITION | |
PRINT (@TEXT) | |
--SELECT @CSV_COLUMN AS CSV_COLUMN,@QUOTED_DATA AS QUOTED_DATA,@TEXT TEXT | |
EXECUTE (@TEXT) | |
SET NOCOUNT OFF | |
END | |
exec sp_generate_insertscripts 'Usuario' , ' where sdni = ''000000''' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment