Answer / honey

by using scope_identity()

Answer / honey

SELECT @@IDENTITY
It returns the last IDENTITY value produced on a
connection, regardless of the table that produced the
value, and regardless of the scope of the statement that
produced the value.
@@IDENTITY will return the last identity value entered into
a table in your current session. While @@IDENTITY is
limited to the current session, it is not limited to the
current scope. If you have a trigger on a table that causes
an identity to be created in another table, you will get
the identity that was created last, even if it was the
trigger that created it.

SELECT SCOPE_IDENTITY()
It returns the last IDENTITY value produced on a connection
and by a statement in the same scope, regardless of the
table that produced the value.
SCOPE_IDENTITY(), like @@IDENTITY, will return the last
identity value created in the current session, but it will
also limit it to your current scope as well. In other
words, it will return the last identity value that you
explicitly created, rather than any identity that was
created by a trigger or a user defined function.

SELECT IDENT_CURRENT(‘tablename’)
It returns the last IDENTITY value produced in a table,
regardless of the connection that created the value, and
regardless of the scope of the statement that produced the
value.
IDENT_CURRENT is not limited by scope and session; it is
limited to a specified table. IDENT_CURRENT returns the
identity value generated for a specific table in any
session and any scope.

To avoid the potential problems associated with adding a
trigger later on, always use SCOPE_IDENTITY() to return the
identity of the recently added row in your T SQL Statement
or Stored Procedure.

How to recover from sql injection? : sql server security

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

Is t sql the same as sql server?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

When we should use @@error?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

What does the on delete cascade option do?

0 Answers  

---