CREATE PROCEDURE [dbo].[VTABLE]  
   @input_table_name nvarchar(max),
   /*
   *   SSMA warning messages:
   *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
   */

   @input_full_report float(53) = 0
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   BEGIN

      DECLARE
         /*
         *   SSMA warning messages:
         *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
         */

         @table_count float(53)

      SELECT @table_count = count(0)
      FROM sysobjects
      WHERE xtype='U' AND name = @input_table_name


      IF @table_count = 1 AND @input_full_report = 1
         PRINT 'Verify table ' + ISNULL(@input_table_name, '') + ' succeeded.'
      ELSE
         BEGIN
            IF @table_count = 0
               PRINT 'ERROR:  Verify table ' + ISNULL(@input_table_name, '') + ' failed.  Table not found.'
         END

   END
GO