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 is SCOPE_IDENTITY() in sql

Answer Posted / deepthi

It will return the value of Auto Increment column , for the
newly inserted row value.

Is This Answer Correct ?    35 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clustered primary key?

958


Does hive support indexing?

905


Explain what is the function of sql server agent windows service?

941


How you can change the database name in SQL SERVER?

1131


How do you delete a data source?

952


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

933


What is the return type of executeupdate ()?

856


What is the command used to check locks in microsoft sql server?

968


What is partition index in sql server?

1046


What are functions in the sql server?

1126


What is a full text index?

871


What is difference between equi join and inner join?

856


What does normalization do to data?

988


Explain what is cte (common table expression)?

1065


What is unique key constraint?

987