SQL將所有資料表放入MemoryCache

DECLARE @TableName NVarChar(max)
DECLARE @TSQL NVarChar(max)

DECLARE curSelect CURSOR FAST_FORWARD FOR
SELECT name FROM sys.tables WHERE type='U' ORDER BY name;

OPEN curSelect

FETCH NEXT FROM curSelect
INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
SET @TSQL=N'
SELECT * FROM '+@TableName
EXEC(@TSQL);

WAITFOR DELAY '00:00:01'

    FETCH NEXT FROM curSelect
    INTO @TableName
END
CLOSE curSelect;
DEALLOCATE curSelect;