Answer / deepthi

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

Answer / vipul

When new row insert into table its we can get value of auto
increment column using SCOPE_IDENTITY()

Answer / ranjani

Scope_Identity() returns last identity value inserted into
an identity column in the same scope.

Answer / cow

scope identity will give you the last generated value for
the current session/scope. Note that @@identity is across
sessions.

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

How do I view a procedure in sql server?

0 Answers  

---

---

List the different types of joins?

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

What is the default server name for sql server?

0 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

how can a database be repaired? : Sql server administration

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---