This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @RowsToProcess bigint | |
DECLARE @CurrentRow bigint | |
DECLARE @SelectTable VARCHAR(50) | |
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL | |
DROP TABLE #Worksheets | |
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30)) | |
INSERT INTO #Worksheets | |
EXEC sp_tables_ex |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @RowsToProcess bigint | |
DECLARE @CurrentRow bigint | |
DECLARE @SelectTable VARCHAR(50) | |
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL | |
DROP TABLE #Worksheets | |
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30)) | |
INSERT INTO #Worksheets | |
EXEC sp_tables_ex |