1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

Question Posted / ram dev


what are the maximum number of rows that can be constructed by inserting rows directly in value list..

Answer / Satish Kumar Deepak

The maximum number of rows that can be inserted using a single VALUES list in T-SQL depends on the version of SQL Server. For SQL Server 2014 and earlier, the limit is 2^31 - 1 (approximately 2 billion). For SQL Server 2016 and later, there is no explicit row count limit.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

What is case function?

1 Answers  

What are synonyms in sql?

1 Answers  

How to call a javascript function from pl sql?

1 Answers  

Show the cursor attributes of pl/sql.

1 Answers  

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

What is the difference between unique and primary key constraints?

1 Answers  

can i call procedure in package

3 Answers   TCS,

Where is all the data on the internet stored?

1 Answers  

what is the difference between union and union all? : Sql dba

1 Answers  

Which join is default?

1 Answers  

Explain what is a subquery ?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories