Home » Archive by categoryUncategorized (Page 2)

Store Procedure To Generate Class From Table

*********** Execute StoreProcedure ********************** sp_GenerateClassFromTable 'TableName' *********** StoreProcedure to store ********************* CREATE proc [dbo].[sp_GenerateClassFromTable] ( @TableName NVARCHAR(50) ) as DECLARE @ProtdVars NVARCHAR(max),@PublicProps NVARCHAR(max), @CMDProps NVARCHAR(max), @InsertStmt NVARCHAR(max), @UpdateStmt NVARCHAR(max) Declare @MyString nvarchar(max), @NewLineChar AS CHAR(2) SET @NewLineChar = Char(13) + CHAR(10) DECLARE @ColName NVARCHAR(20), @ColType NVARCHAR(10) DECLARE @Value...
Continue reading

Subscribe

Join 901 other subscribers