@manhnguyenv

Welcome to my blog!

T4 Generator

March 19, 2020 22:42

T4 Generator (edit)

Given name of stored procedure, generate C# class to using it:

https://www.codeproject.com/Articles/29416/Class-Generator-for-SQL-Server-Stored-Procedures (17 Sep 2008)

https://gist.github.com/litera/11205851

https://www.codeproject.com/Articles/8397/C-Code-Generator-for-Stored-Procedures (2006)

https://www.codeproject.com/Articles/7592/Wrapper-Generator-for-SQL-Server-Stored-Procedures (1 Jul 2004)

https://www.codeproject.com/Articles/8827/Stored-Procedure-class-generator (22 Nov 2004)

https://sourceforge.net/projects/spcaller/

VIEW NULLABLE OF PARAMS

DECLARE @Lines TABLE (Line NVARCHAR(MAX)) ;
DECLARE @FullText NVARCHAR(MAX) = '' ;

INSERT @Lines EXEC sp_helptext 'InsertLogFailedLogin' ;
SELECT @FullText = @FullText + Line FROM @Lines ;
PRINT @FullText

Categories

Recent posts