Skip to content
Home » Table Value Constructor

Table Value Constructor

Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement.



It can be used as a part of either the VALUES clause of an INSERT INTO VALUES statement, or as a derived table in either the USING clause of the MERGE statement or the FROM clause in DML statement.

When Table Value Constructor used as a VALUES clause of an INSERT INTO VALUES statement, there is a limit of 1000 rows, while when it is used as derived table then there is no limit to the number of rows.

SYNTAX

VALUES( {DEFAULT|NULL|<expression>} [,...n] ) [,...n]

VALUES
is the row value expression lists. Each list must be enclosed in parentheses and separated by a comma, and the number of values specified in each list must be the same and the values must be in the same order as the columns in the table.

DEFAULT
It inserts the default value defined for a column. If a default does not exist for the column and the column allows null values, NULL is inserted. DEFAULT is not valid for an identity column. When specified in a table value constructor, DEFAULT is allowed only in an INSERT statement.

NULL

When null is specified in table value constructor a null value is defined for a column. NULL is not valid for an identity column.

expression
Is a constant, a variable, or an expression.

Lets look at an example of Table Value Constructor in SQL.

First we create a sample table named ItemList as shown below.

CREATE TABLE dbo.ItemList
(Id INT IDENTITY(1,1),
ItemName VARCHAR(100),
ItemCode VARCHAR(10) NULL ,
Amount NUMERIC(8,2) DEFAULT 1000)

Inserting multiple records using Table Value Constructor

Lets insert the multiple records in table ItemList using Table Value Constructor.

In following T-SQL, you can see multiple records are inserted into table using Table Value constructor which seems like a traditional INSERT INTO statement except that there are multiple sets of parentheses in the VALUES clause, where each rows enclosed in the parentheses includes the individual row value expressions.

INSERT INTO dbo.ItemList 
(ItemName, ItemCode, Amount)
VALUES 
('Pen Drive', 'PEN-D1', 4000),
('Furniture', 'FUR-LEX', 150000),
('Hard Disk', 'SEAG', 5000) ,
('White Paper', 'W-PP', 2500);

Lets verify whether the records into table are inserted or not.

 SELECT * FROM dbo.ItemList

You can see, records are inserted into table. TVC is very helpful when you want to insert a multiple rows of hard-coded values into a table with just one insert statement.

Using Table Value Constructor in select statement

In following T-SQL, you can see each row is enclosed in a set of parentheses and the two values in each row are separated with a comma.

As a result, the TVC returns a table named Tbl which includes two columns specified as (Id, Alphabet).

SELECT * FROM
(
VALUES
(1,'A'), 
(2,'B'),
(3,'C'),
(4,'D')
) AS Tbl (Id, Alphabet)

You can see, It returns 4 rows for two columns Id and Alphabet.



Using Table Value Constructor in Join

You can also use the table value constructor in joins, by specifying a multiple values as a derived table in a FROM clause and join that derived table with other table using SQL Joins.

In following T-SQL,  a SELECT statement defines an inner join that includes a table ItemList and a derived table ItemDesc produced by TVC.

SELECT 
  Itm.Id, 
  Itm.ItemName, 
  Itm.ItemCode, 
  Itm.ItemName,
  ItemDesc.ItemDescription 
FROM dbo.ItemList Itm 
INNER JOIN 
( VALUES
(1,'HP 32 GB Pendrive'), 
(2,'Textile Group - Furniture'),
(3,'Seagate 500GB Hard Disk'),
(4,'Premium Quality Papers')
) AS ItemDesc (Id, ItemDescription) 
ON Itm.Id =ItemDesc.Id

You can see, it returns a Item details along with Item Description which comes from derived table using a TVC.

Inserting multiple rows with DEFAULT and NULL values 

Lets specify a DEFAULT and NULL when using the table value constructor to insert rows into a table.




You can see a Default is specified for column Amount in first row while a NULL is specified for column ItemCode in second rows.

INSERT INTO dbo.ItemList 
(ItemName, ItemCode, Amount)
VALUES 
('KeyBoard', 'Key-QWTRY', DEFAULT),
('Tublight', NULL, 30000)

Lets check the table, and you can see a default value 1000 is inserted in amount column for first record and a null value is inserted in ItemCode column for second record.

Table Value Constructor with 1000 + Rows

When Table Value Constructor used as a VALUES clause of an INSERT INTO VALUES statement, there is a limit of 1000 rows, while when it is used as derived table then there is no limit to the number of rows.

Using TVC as a VALUES clause of an INSERT INTO VALUES statement for inserting 1001 rows into table.

Lets try to insert more than 1000 rows using TVC, first we create a sample table named Numbers.

CREATE TABLE dbo.NumberList(ID INT)

Lets insert 10001 records into table NumberList.



INSERT INTO dbo.NumberList(Id)
VALUES
('1'), ('2'), ('3'), ('4'), ('5'), ('6'), ('7'), ('8'), ('9'), ('10'), ('11'), ('12'), ('13'), ('14'), ('15'), ('16'), ('17'), ('18'), ('19'), ('20'), ('21'), ('22'), ('23'), ('24'), ('25'), ('26'), ('27'), ('28'), ('29'), ('30'), ('31'), ('32'), ('33'), ('34'), ('35'), ('36'), ('37'), ('38'), ('39'), ('40'), ('41'), ('42'), ('43'), ('44'), ('45'), ('46'), ('47'), ('48'), ('49'), ('50'), ('51'), ('52'), ('53'), ('54'), ('55'), ('56'), ('57'), ('58'), ('59'), ('60'), ('61'), ('62'), ('63'), ('64'), ('65'), ('66'), ('67'), ('68'), ('69'), ('70'), ('71'), ('72'), ('73'), ('74'), ('75'), ('76'), ('77'), ('78'), ('79'), ('80'), ('81'), ('82'), ('83'), ('84'), ('85'), ('86'), ('87'), ('88'), ('89'), ('90'), ('91'), ('92'), ('93'), ('94'), ('95'), ('96'), ('97'), ('98'), ('99'), ('100'), ('101'), ('102'), ('103'), ('104'), ('105'), ('106'), ('107'), ('108'), ('109'), ('110'), ('111'), ('112'), ('113'), ('114'), ('115'), ('116'), ('117'), ('118'), ('119'), ('120'), ('121'), ('122'), ('123'), ('124'), ('125'), ('126'), ('127'), ('128'), ('129'), ('130'), ('131'), ('132'), ('133'), ('134'), ('135'), ('136'), ('137'), ('138'), ('139'), ('140'), ('141'), ('142'), ('143'), ('144'), ('145'), ('146'), ('147'), ('148'), ('149'), ('150'), ('151'), ('152'), ('153'), ('154'), ('155'), ('156'), ('157'), ('158'), ('159'), ('160'), ('161'), ('162'), ('163'), ('164'), ('165'), ('166'), ('167'), ('168'), ('169'), ('170'), ('171'), ('172'), ('173'), ('174'), ('175'), ('176'), ('177'), ('178'), ('179'), ('180'), ('181'), ('182'), ('183'), ('184'), ('185'), ('186'), ('187'), ('188'), ('189'), ('190'), ('191'), ('192'), ('193'), ('194'), ('195'), ('196'), ('197'), ('198'), ('199'), ('200'), ('201'), ('202'), ('203'), ('204'), ('205'), ('206'), ('207'), ('208'), ('209'), ('210'), ('211'), ('212'), ('213'), ('214'), ('215'), ('216'), ('217'), ('218'), ('219'), ('220'), ('221'), ('222'), ('223'), ('224'), ('225'), ('226'), ('227'), ('228'), ('229'), ('230'), ('231'), ('232'), ('233'), ('234'), ('235'), ('236'), ('237'), ('238'), ('239'), ('240'), ('241'), ('242'), ('243'), ('244'), ('245'), ('246'), ('247'), ('248'), ('249'), ('250'), ('251'), ('252'), ('253'), ('254'), ('255'), ('256'), ('257'), ('258'), ('259'), ('260'), ('261'), ('262'), ('263'), ('264'), ('265'), ('266'), ('267'), ('268'), ('269'), ('270'), ('271'), ('272'), ('273'), ('274'), ('275'), ('276'), ('277'), ('278'), ('279'), ('280'), ('281'), ('282'), ('283'), ('284'), ('285'), ('286'), ('287'), ('288'), ('289'), ('290'), ('291'), ('292'), ('293'), ('294'), ('295'), ('296'), ('297'), ('298'), ('299'), ('300'), ('301'), ('302'), ('303'), ('304'), ('305'), ('306'), ('307'), ('308'), ('309'), ('310'), ('311'), ('312'), ('313'), ('314'), ('315'), ('316'), ('317'), ('318'), ('319'), ('320'), ('321'), ('322'), ('323'), ('324'), ('325'), ('326'), ('327'), ('328'), ('329'), ('330'), ('331'), ('332'), ('333'), ('334'), ('335'), ('336'), ('337'), ('338'), ('339'), ('340'), ('341'), ('342'), ('343'), ('344'), ('345'), ('346'), ('347'), ('348'), ('349'), ('350'), ('351'), ('352'), ('353'), ('354'), ('355'), ('356'), ('357'), ('358'), ('359'), ('360'), ('361'), ('362'), ('363'), ('364'), ('365'), ('366'), ('367'), ('368'), ('369'), ('370'), ('371'), ('372'), ('373'), ('374'), ('375'), ('376'), ('377'), ('378'), ('379'), ('380'), ('381'), ('382'), ('383'), ('384'), ('385'), ('386'), ('387'), ('388'), ('389'), ('390'), ('391'), ('392'), ('393'), ('394'), ('395'), ('396'), ('397'), ('398'), ('399'), ('400'), ('401'), ('402'), ('403'), ('404'), ('405'), ('406'), ('407'), ('408'), ('409'), ('410'), ('411'), ('412'), ('413'), ('414'), ('415'), ('416'), ('417'), ('418'), ('419'), ('420'), ('421'), ('422'), ('423'), ('424'), ('425'), ('426'), ('427'), ('428'), ('429'), ('430'), ('431'), ('432'), ('433'), ('434'), ('435'), ('436'), ('437'), ('438'), ('439'), ('440'), ('441'), ('442'), ('443'), ('444'), ('445'), ('446'), ('447'), ('448'), ('449'), ('450'), ('451'), ('452'), ('453'), ('454'), ('455'), ('456'), ('457'), ('458'), ('459'), ('460'), ('461'), ('462'), ('463'), ('464'), ('465'), ('466'), ('467'), ('468'), ('469'), ('470'), ('471'), ('472'), ('473'), ('474'), ('475'), ('476'), ('477'), ('478'), ('479'), ('480'), ('481'), ('482'), ('483'), ('484'), ('485'), ('486'), ('487'), ('488'), ('489'), ('490'), ('491'), ('492'), ('493'), ('494'), ('495'), ('496'), ('497'), ('498'), ('499'), ('500'), ('501'), ('502'), ('503'), ('504'), ('505'), ('506'), ('507'), ('508'), ('509'), ('510'), ('511'), ('512'), ('513'), ('514'), ('515'), ('516'), ('517'), ('518'), ('519'), ('520'), ('521'), ('522'), ('523'), ('524'), ('525'), ('526'), ('527'), ('528'), ('529'), ('530'), ('531'), ('532'), ('533'), ('534'), ('535'), ('536'), ('537'), ('538'), ('539'), ('540'), ('541'), ('542'), ('543'), ('544'), ('545'), ('546'), ('547'), ('548'), ('549'), ('550'), ('551'), ('552'), ('553'), ('554'), ('555'), ('556'), ('557'), ('558'), ('559'), ('560'), ('561'), ('562'), ('563'), ('564'), ('565'), ('566'), ('567'), ('568'), ('569'), ('570'), ('571'), ('572'), ('573'), ('574'), ('575'), ('576'), ('577'), ('578'), ('579'), ('580'), ('581'), ('582'), ('583'), ('584'), ('585'), ('586'), ('587'), ('588'), ('589'), ('590'), ('591'), ('592'), ('593'), ('594'), ('595'), ('596'), ('597'), ('598'), ('599'), ('600'), ('601'), ('602'), ('603'), ('604'), ('605'), ('606'), ('607'), ('608'), ('609'), ('610'), ('611'), ('612'), ('613'), ('614'), ('615'), ('616'), ('617'), ('618'), ('619'), ('620'), ('621'), ('622'), ('623'), ('624'), ('625'), ('626'), ('627'), ('628'), ('629'), ('630'), ('631'), ('632'), ('633'), ('634'), ('635'), ('636'), ('637'), ('638'), ('639'), ('640'), ('641'), ('642'), ('643'), ('644'), ('645'), ('646'), ('647'), ('648'), ('649'), ('650'), ('651'), ('652'), ('653'), ('654'), ('655'), ('656'), ('657'), ('658'), ('659'), ('660'), ('661'), ('662'), ('663'), ('664'), ('665'), ('666'), ('667'), ('668'), ('669'), ('670'), ('671'), ('672'), ('673'), ('674'), ('675'), ('676'), ('677'), ('678'), ('679'), ('680'), ('681'), ('682'), ('683'), ('684'), ('685'), ('686'), ('687'), ('688'), ('689'), ('690'), ('691'), ('692'), ('693'), ('694'), ('695'), ('696'), ('697'), ('698'), ('699'), ('700'), ('701'), ('702'), ('703'), ('704'), ('705'), ('706'), ('707'), ('708'), ('709'), ('710'), ('711'), ('712'), ('713'), ('714'), ('715'), ('716'), ('717'), ('718'), ('719'), ('720'), ('721'), ('722'), ('723'), ('724'), ('725'), ('726'), ('727'), ('728'), ('729'), ('730'), ('731'), ('732'), ('733'), ('734'), ('735'), ('736'), ('737'), ('738'), ('739'), ('740'), ('741'), ('742'), ('743'), ('744'), ('745'), ('746'), ('747'), ('748'), ('749'), ('750'), ('751'), ('752'), ('753'), ('754'), ('755'), ('756'), ('757'), ('758'), ('759'), ('760'), ('761'), ('762'), ('763'), ('764'), ('765'), ('766'), ('767'), ('768'), ('769'), ('770'), ('771'), ('772'), ('773'), ('774'), ('775'), ('776'), ('777'), ('778'), ('779'), ('780'), ('781'), ('782'), ('783'), ('784'), ('785'), ('786'), ('787'), ('788'), ('789'), ('790'), ('791'), ('792'), ('793'), ('794'), ('795'), ('796'), ('797'), ('798'), ('799'), ('800'), ('801'), ('802'), ('803'), ('804'), ('805'), ('806'), ('807'), ('808'), ('809'), ('810'), ('811'), ('812'), ('813'), ('814'), ('815'), ('816'), ('817'), ('818'), ('819'), ('820'), ('821'), ('822'), ('823'), ('824'), ('825'), ('826'), ('827'), ('828'), ('829'), ('830'), ('831'), ('832'), ('833'), ('834'), ('835'), ('836'), ('837'), ('838'), ('839'), ('840'), ('841'), ('842'), ('843'), ('844'), ('845'), ('846'), ('847'), ('848'), ('849'), ('850'), ('851'), ('852'), ('853'), ('854'), ('855'), ('856'), ('857'), ('858'), ('859'), ('860'), ('861'), ('862'), ('863'), ('864'), ('865'), ('866'), ('867'), ('868'), ('869'), ('870'), ('871'), ('872'), ('873'), ('874'), ('875'), ('876'), ('877'), ('878'), ('879'), ('880'), ('881'), ('882'), ('883'), ('884'), ('885'), ('886'), ('887'), ('888'), ('889'), ('890'), ('891'), ('892'), ('893'), ('894'), ('895'), ('896'), ('897'), ('898'), ('899'), ('900'), ('901'), ('902'), ('903'), ('904'), ('905'), ('906'), ('907'), ('908'), ('909'), ('910'), ('911'), ('912'), ('913'), ('914'), ('915'), ('916'), ('917'), ('918'), ('919'), ('920'), ('921'), ('922'), ('923'), ('924'), ('925'), ('926'), ('927'), ('928'), ('929'), ('930'), ('931'), ('932'), ('933'), ('934'), ('935'), ('936'), ('937'), ('938'), ('939'), ('940'), ('941'), ('942'), ('943'), ('944'), ('945'), ('946'), ('947'), ('948'), ('949'), ('950'), ('951'), ('952'), ('953'), ('954'), ('955'), ('956'), ('957'), ('958'), ('959'), ('960'), ('961'), ('962'), ('963'), ('964'), ('965'), ('966'), ('967'), ('968'), ('969'), ('970'), ('971'), ('972'), ('973'), ('974'), ('975'), ('976'), ('977'), ('978'), ('979'), ('980'), ('981'), ('982'), ('983'), ('984'), ('985'), ('986'), ('987'), ('988'), ('989'), ('990'), ('991'), ('992'), ('993'), ('994'), ('995'), ('996'), ('997'), ('998'), ('999'), ('1000'), ('1001')

You can see can, it returns an error. That means it has row limit of 1000 when it is used as a VALUES clause of an INSERT INTO VALUES statement.

Lets see what happens when you use TVC as a derived table, and you can see it does not return error.

SELECT * FROM (
VALUES 
('1'), ('2'), ('3'), ('4'), ('5'), ('6'), ('7'), ('8'), ('9'), ('10'), ('11'), ('12'), ('13'), ('14'), ('15'), ('16'), ('17'), ('18'), ('19'), ('20'), ('21'), ('22'), ('23'), ('24'), ('25'), ('26'), ('27'), ('28'), ('29'), ('30'), ('31'), ('32'), ('33'), ('34'), ('35'), ('36'), ('37'), ('38'), ('39'), ('40'), ('41'), ('42'), ('43'), ('44'), ('45'), ('46'), ('47'), ('48'), ('49'), ('50'),('51'), ('52'), ('53'), ('54'), ('55'), ('56'), ('57'), ('58'), ('59'), ('60'), ('61'), ('62'), ('63'), ('64'), ('65'), ('66'), ('67'), ('68'), ('69'), ('70'), ('71'), ('72'), ('73'), ('74'), ('75'), ('76'), ('77'), ('78'), ('79'), ('80'), ('81'), ('82'), ('83'), ('84'), ('85'), ('86'), ('87'), ('88'), ('89'), ('90'), ('91'), ('92'), ('93'), ('94'), ('95'), ('96'), ('97'), ('98'), ('99'), ('100'), ('101'), ('102'), ('103'), ('104'), ('105'), ('106'), ('107'), ('108'), ('109'), ('110'), ('111'), ('112'), ('113'), ('114'), ('115'), ('116'), ('117'), ('118'), ('119'), ('120'), ('121'), ('122'), ('123'), ('124'), ('125'), ('126'), ('127'), ('128'), ('129'), ('130'), ('131'), ('132'), ('133'), ('134'), ('135'), ('136'), ('137'), ('138'), ('139'), ('140'), ('141'), ('142'), ('143'), ('144'), ('145'),('146'), ('147'), ('148'), ('149'), ('150'), ('151'), ('152'), ('153'), ('154'), ('155'), ('156'), ('157'), ('158'), ('159'), ('160'), ('161'), ('162'), ('163'), ('164'), ('165'), ('166'), ('167'), ('168'), ('169'), ('170'), ('171'), ('172'), ('173'), ('174'), ('175'), ('176'), ('177'), ('178'), ('179'), ('180'), ('181'), ('182'), ('183'), ('184'), ('185'), ('186'), ('187'), ('188'), ('189'), ('190'), ('191'), ('192'), ('193'), ('194'), ('195'), ('196'), ('197'), ('198'), ('199'),('200'), ('201'), ('202'), ('203'), ('204'), ('205'), ('206'), ('207'), ('208'), ('209'), ('210'), ('211'), ('212'), ('213'), ('214'), ('215'), ('216'), ('217'), ('218'), ('219'), ('220'), ('221'), ('222'), ('223'), ('224'), ('225'), ('226'), ('227'), ('228'), ('229'), ('230'), ('231'), ('232'), ('233'), ('234'), ('235'), ('236'), ('237'), ('238'), ('239'), ('240'), ('241'), ('242'), ('243'), ('244'), ('245'), ('246'), ('247'), ('248'), ('249'), ('250'), ('251'), ('252'), ('253'), ('254'), ('255'), ('256'), ('257'), ('258'), ('259'), ('260'), ('261'), ('262'), ('263'), ('264'), ('265'), ('266'), ('267'), ('268'), ('269'), ('270'), ('271'), ('272'), ('273'), ('274'), ('275'), ('276'), ('277'), ('278'), ('279'), ('280'), ('281'), ('282'), ('283'), ('284'), ('285'), ('286'), ('287'), ('288'), ('289'), ('290'), ('291'), ('292'), ('293'), ('294'), ('295'), ('296'), ('297'), ('298'),('299'), ('300'), ('301'), ('302'), ('303'), ('304'), ('305'), ('306'), ('307'), ('308'), ('309'), ('310'), ('311'), ('312'), ('313'), ('314'), ('315'), ('316'), ('317'), ('318'), ('319'), ('320'), ('321'), ('322'), ('323'), ('324'), ('325'), ('326'), ('327'), ('328'), ('329'), ('330'), ('331'), ('332'), ('333'), ('334'),('335'), ('336'), ('337'), ('338'), ('339'), ('340'), ('341'), ('342'), ('343'),('344'), ('345'), ('346'), ('347'), ('348'), ('349'), ('350'), ('351'), ('352'),('353'), ('354'), ('355'), ('356'), ('357'), ('358'), ('359'), ('360'), ('361'),('362'), ('363'), ('364'), ('365'), ('366'), ('367'), ('368'), ('369'), ('370'),('371'), ('372'), ('373'), ('374'), ('375'), ('376'), ('377'), ('378'), ('379'), ('380'), ('381'), ('382'), ('383'), ('384'), ('385'), ('386'), ('387'), ('388'),('389'), ('390'), ('391'), ('392'), ('393'), ('394'), ('395'), ('396'), ('397'),('398'), ('399'), ('400'), ('401'), ('402'), ('403'), ('404'), ('405'), ('406'), ('407'), ('408'), ('409'), ('410'), ('411'), ('412'), ('413'), ('414'), ('415'), ('416'), ('417'), ('418'), ('419'), ('420'), ('421'), ('422'), ('423'), ('424'), ('425'), ('426'), ('427'), ('428'), ('429'), ('430'), ('431'), ('432'), ('433'),('434'), ('435'), ('436'), ('437'), ('438'), ('439'), ('440'), ('441'), ('442'),('443'), ('444'), ('445'), ('446'), ('447'), ('448'), ('449'), ('450'), ('451'), ('452'), ('453'), ('454'), ('455'), ('456'), ('457'), ('458'), ('459'), ('460'), ('461'), ('462'), ('463'), ('464'), ('465'), ('466'), ('467'), ('468'), ('469'), ('470'), ('471'), ('472'), ('473'), ('474'), ('475'), ('476'), ('477'), ('478'), ('479'), ('480'), ('481'), ('482'), ('483'), ('484'), ('485'), ('486'), ('487'),('488'), ('489'), ('490'), ('491'), ('492'), ('493'), ('494'), ('495'), ('496'), ('497'), ('498'), ('499'), ('500'), ('501'), ('502'), ('503'), ('504'), ('505'), ('506'), ('507'), ('508'), ('509'), ('510'), ('511'), ('512'), ('513'), ('514'), ('515'), ('516'), ('517'), ('518'), ('519'), ('520'), ('521'), ('522'), ('523'), ('524'), ('525'), ('526'), ('527'), ('528'), ('529'), ('530'), ('531'), ('532'), ('533'), ('534'), ('535'), ('536'), ('537'), ('538'), ('539'), ('540'), ('541'),('542'), ('543'), ('544'), ('545'), ('546'), ('547'), ('548'), ('549'), ('550'), ('551'), ('552'), ('553'), ('554'), ('555'), ('556'), ('557'), ('558'), ('559'), ('560'), ('561'), ('562'), ('563'), ('564'), ('565'), ('566'), ('567'), ('568'), ('569'), ('570'), ('571'), ('572'), ('573'), ('574'), ('575'), ('576'), ('577'), ('578'), ('579'), ('580'), ('581'), ('582'), ('583'), ('584'),('585'), ('586'), ('587'), ('588'), ('589'), ('590'), ('591'), ('592'), ('593'), ('594'), ('595'), ('596'), ('597'), ('598'), ('599'), ('600'), ('601'), ('602'), ('603'), ('604'), ('605'), ('606'), ('607'), ('608'), ('609'), ('610'), ('611'), ('612'), ('613'), ('614'), ('615'), ('616'), ('617'), ('618'), ('619'), ('620'), ('621'), ('622'), ('623'), ('624'), ('625'), ('626'), ('627'), ('628'), ('629'), ('630'), ('631'), ('632'), ('633'), ('634'), ('635'), 
('636'), ('637'), ('638'), ('639'), ('640'), ('641'), ('642'), ('643'), ('644'), ('645'), ('646'), ('647'), ('648'), ('649'), ('650'), ('651'), ('652'), ('653'), ('654'), ('655'), ('656'), ('657'), ('658'), ('659'), ('660'), ('661'), ('662'), ('663'), ('664'), ('665'), ('666'), ('667'), ('668'), ('669'),('670'), ('671'), ('672'), ('673'), ('674'), ('675'), ('676'), ('677'), ('678'), ('679'), ('680'), ('681'), ('682'), ('683'), ('684'), ('685'), ('686'),('687'), ('688'), ('689'), ('690'), ('691'), ('692'), ('693'), ('694'), ('695'), ('696'), ('697'), ('698'), ('699'), ('700'), ('701'), ('702'), ('703'), ('704'), ('705'), ('706'), ('707'), ('708'), ('709'), ('710'), ('711'), ('712'), ('713'), ('714'), ('715'), ('716'), ('717'), ('718'), ('719'), ('720'),('721'), ('722'), ('723'), ('724'), ('725'), ('726'), ('727'), ('728'), ('729'), ('730'), ('731'), ('732'), ('733'), ('734'), ('735'), ('736'), ('737'),('738'), ('739'), ('740'), ('741'), ('742'), ('743'), ('744'), ('745'), ('746'), ('747'), ('748'), ('749'), ('750'), ('751'), ('752'), ('753'), ('754'),('755'), ('756'), ('757'), ('758'), ('759'), ('760'), ('761'), ('762'), ('763'), ('764'), ('765'), ('766'), ('767'), ('768'), ('769'), ('770'), ('771'),('772'), ('773'), ('774'), ('775'), ('776'), ('777'), ('778'), ('779'), ('780'), ('781'), ('782'), ('783'), ('784'), ('785'), ('786'), ('787'), ('788'),('789'), ('790'), ('791'), ('792'), ('793'), ('794'), ('795'), ('796'), ('797'), ('798'), ('799'), ('800'), ('801'), ('802'), ('803'), ('804'), ('805'), ('806'), ('807'), ('808'), ('809'), ('810'), ('811'), ('812'), ('813'), ('814'), ('815'), ('816'), ('817'), ('818'), ('819'), ('820'), ('821'), ('822'),('823'), ('824'), ('825'), ('826'), ('827'), ('828'), ('829'), ('830'), ('831'), ('832'), ('833'), ('834'), ('835'), ('836'), ('837'), ('838'), ('839'),('840'), ('841'), ('842'), ('843'), ('844'), ('845'), ('846'), ('847'), ('848'), ('849'), ('850'), ('851'), ('852'), ('853'), ('854'), ('855'), ('856'),('857'), ('858'), ('859'), ('860'), ('861'), ('862'), ('863'), ('864'), ('865'), ('866'), ('867'), ('868'), ('869'), ('870'), ('871'), ('872'), ('873'),
('874'), ('875'), ('876'), ('877'), ('878'), ('879'), ('880'), ('881'), ('882'), ('883'), ('884'), ('885'), ('886'), ('887'), ('888'), ('889'), ('890'),('891'), ('892'), ('893'), ('894'), ('895'), ('896'), ('897'), ('898'), ('899'), ('900'), ('901'), ('902'), ('903'), ('904'), ('905'), ('906'), ('907'), ('908'), ('909'), ('910'), ('911'), ('912'), ('913'), ('914'), ('915'), ('916'), ('917'), ('918'), ('919'), ('920'), ('921'), ('922'), ('923'), ('924'),('925'), ('926'), ('927'), ('928'), ('929'), ('930'), ('931'), ('932'), ('933'), ('934'), ('935'), ('936'), ('937'), ('938'), ('939'), ('940'), ('941'),('942'), ('943'), ('944'), ('945'), ('946'), ('947'), ('948'), ('949'), ('950'), ('951'), ('952'), ('953'), ('954'), ('955'), ('956'), ('957'), ('958'), ('959'), ('960'), ('961'), ('962'), ('963'), ('964'), ('965'), ('966'), ('967'), ('968'), ('969'), ('970'), ('971'), ('972'), ('973'), ('974'), ('975'),('976'), ('977'), ('978'), ('979'), ('980'), ('981'), ('982'), ('983'), ('984'), ('985'), ('986'), ('987'), ('988'), ('989'), ('990'), ('991'), ('992'),('993'), ('994'), ('995'), ('996'), ('997'), ('998'), ('999'), ('1000'), ('1001')) AS TBL (ID)

Also Read..

SQL basics Tutorial

SQL Advance Tutorial

SSRS Tutorial




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




Loading

Tags:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.