text: ﻿CREATE PROCEDURE [sprockit_Event].[test Validate sprockit.Event ExecutionId]
  AS
   
  -- ARRANGE
  DECLARE @tableSchema SYSNAME = 'sprockit';
  DECLARE @tableName SYSNAME = 'Event';
  DECLARE @columnName SYSNAME = 'ExecutionId';
   
  SELECT *
  INTO #expected
  FROM tsqlt_test_utils.TableColumnAttributes
  WHERE 0 = 1;
   
  INSERT INTO #expected (
    [TableSchema]
  , [TableName]
  , [ColumnName]
  , [TypeName]
  , [max_length]
  , [precision]
  , [scale]
  , [is_nullable]
  ) VALUES (
    @tableSchema
  , @tableName
  , @columnName
  , 'int'
  , 4
  , 10
  , 0
  , 1
  );
   
  -- ACT
  SELECT *
  INTO #actual
  FROM tsqlt_test_utils.TableColumnAttributes
  WHERE TableName = @tableName
  AND ColumnName = @columnName;
   
  -- ASSERT
  EXEC tSQLt.AssertEqualsTable 
    @Expected = '#expected'
  , @Actual = '#actual';
  