New Features in SQL server 2019 - Table Variables
USE [SQLDepository]
GO
ALTER DATABASE [SQLDepository] SET COMPATIBILITY_LEVEL = 140
DECLARE @Test TABLE
(ID int IDENTITY,
Cal varchar(50))
INSERT INTO @Test Values (RAND()),(RAND()),(RAND()),(RAND()),(RAND()),(RAND()),(RAND())
Select * from @Test
GO
ALTER DATABASE [SQLDepository] SET COMPATIBILITY_LEVEL = 150
DECLARE @Test TABLE
(ID int IDENTITY,
Cal varchar(50))
INSERT INTO @Test Values (RAND()),(RAND()),(RAND()),(RAND()),(RAND()),(RAND()),(RAND())
Select * from @Test