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...

Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.

I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times???

Answer Posted / deepak

Madhu, actually the answer which u have given is quite
common. Now i m gonna tell u a new one. The above question
has one more solution that is stated below:


"Insert into Table_name DEFAULT values"


that's it.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of containers in ssis?

1168


Do you know what is sql service broker?

1080


What is a mixed extent?

1009


What is coalesce in sql server?

1049


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1053


What is user-defined function?

966


What are differences in between sql server 2012 and sql server 2016?

1039


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1027


Why do we use trigger?

963


What is server-level principal?

122


If user is owning any SQL Objects, can we drop that user

2067


Explain what are the basic functions for master, msdb, model, tempdb databases?

970


What are the steps to insert a table?

943


what are the new features in SSRS?

134


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1941