Database Reference
In-Depth Information
You can see that the column C1 is using the int data type and the column C2 is using
varchar(50) .
If I run a simple select from the table t2 , we will see that the table is empty, as
shown in the following screenshot:
So, with the clustered columnstore index created, you would want to populate
the table with some data. The following INSERT statement will insert two rows
in the table:
USE [DB1]
GO
INSERT INTO [dbo].[t2]
([c1],[c2])
VALUES
(1,'Gethyn'),
(2,'Seth')
GO
 
Search WWH ::




Custom Search