New Features in SQL server 2019 - Table Variables

Описание к видео 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

Комментарии

Информация по комментариям в разработке