Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what are the limitations of parameters in a storedprocedure



what are the limitations of parameters in a storedprocedure..

Answer / karthik

According to MSDN, SQL Server limits the number of parameters per stored procedure to 2,100

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the benefits of normalization?

0 Answers  


Explain the functionalities that views support?

0 Answers  


What is the difference between push and pull subscription? : sql server replication

0 Answers  


one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  


What is the difference between left and right outer join?

0 Answers  


How to update muliple row in single query?

0 Answers   MCN Solutions,


How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  


What is a trigger what are the advantages of trigger?

0 Answers  


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


What is postgresql server?

0 Answers  


What stored by the model? : sql server database administration

0 Answers  


How to choose all records from the table?

0 Answers  


Categories