You are a database administrator on an instance of SQL Server. While creating a table, you decide to implement a sparse column.
Which Transact-SQL will execute successfully and create a table with a sparse column?
A. CREATE TABLE Table1 (
ID int IDENTITY(1,1),
TranDate datetime,
ProductID int SPARSE NOT NULL,
Quantity smallint,
ProdType char(2),
ProdDetails varchar(max));
B. CREATE TABLE Table1 (
ID int SPARSE NULL IDENTITY(1,1),
TranDate datetime,
ProductID int,
Quantity smallint,
ProdType char(2),
ProdDetails varchar(max));
C. CREATE TABLE Table1 (
ID int IDENTITY(1,1),
TranDate datetime,
ProductID int NOT NULL,
Quantity smallint,
ProdType char(2),
ProdDetails varbinary(max) FILESTREAM SPARSE);
D. CREATE TABLE Table1 (
ID int IDENTITY(1,1),
TranDate datetime,
ProductID int SPARSE NULL,
Quantity smallint,
ProdType char(2),
ProdDetails varchar(max));
