[GUIDE] Auto Create Table for LOGDB

CREATE PROCEDURE [dbo].[PROCEDURE_NAME]
    AS
    BEGIN
        
    DECLARE [USER=864679]table[/USER] VARCHAR( 20 )
    SET [USER=864679]table[/USER] = 'TB_ITEM_LOG_' + CONVERT( VARCHAR( 8 ), GETDATE(), 112 )
        
    DECLARE [USER=1333359122]SQL[/USER]String NVARCHAR(MAX)
    Set [USER=1333359122]SQL[/USER]String = 'CREATE TABLE '  [USER=864679]table[/USER]+
    '(
    [LOGIDX]    [INT] IDENTITY(1,1) NOT NULL,
    [LOGTYPE]    [SMALLINT] NOT NULL,
    [FROMCHRIDX]        [INT] NOT NULL, 
    [FROMCHRNAME]    [VARCHAR](16) NOT NULL, 
    [TOCHRIDX]        [INT] NOT NULL, 
    [TOCHRNAME]        [VARCHAR](16) NOT NULL,
    [FROMTOTALMONEY] [BIGINT] NOT NULL,
    [TOTOTALMONEY]    [BIGINT] NULL,
    [CHANGEMONEY]    [BIGINT] NULL,
    [ITEMIDX]        [INT] NULL,
    [ITEMDBIDX]        [INT] NULL,
    [ITEMDUR]        [BIGINT] NULL,
    [ITEMFROMPOS]    [INT] NULL,
    [ITEMTOPOS]        [INT] NULL,
    [REGDATE] [DATETIME] NULL,
    [CHREXPPOINT]    [INT] NOT NULL
) ON [PRIMARY]'


EXEC  [USER=1333359122]SQL[/USER]String)
END

sqlcmd -Q "exec PROC_NAME" -S SERVER_NAME -d DB_NAME -o C:\EXEC_LOG.txt