CREATE PROC procCreateTrgSelectTBL (@tableName      VARCHAR(50))
AS
BEGIN
    DECLARE @sql    NVARCHAR(MAX),
            @statement      NVARCHAR(MAX)

    SET @statement = '
        CREATE TRIGGER trgInsertEmp ON  [MyDB].[dbo].
        FOR INSERT
        AS
        BEGIN
            PRINT(''Test'')
        END'
        SET @sql = 'EXEC ' + QUOTENAME(@tableName) + '.sys.sp_executesql
                    N''EXEC(@statement)''
                    , N''@statement nvarchar(max)''
                    , @statement;'
        EXEC sp_executeSQL @sql, N'@statement nvarchar(max)', @statement
END
EXEC procCreateTrgSelectTBL @tableName = 'Employee'