How to Get the last identity value used

4 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Define the one-to-one relationship while designing tables.

0 Answers  

---

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

0 Answers  

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

What is advantage data architect?

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---