Answer Posted / yvbchowdary

The identity is similar to squence object in oracle. syntax
for identity column is
<column-name> <data type> identity(start value,increment)
ex:
empno int identity(100,2)

suppose if u want to add an odd value i.e, 50; u can also
add
first execute IDENTITY_INSERT ON
and then u can insert whatever values u want. then again
execute IDENTITY_INSERT OFF

What do you mean by data manipulation language?

944

---

Explain what are the events recorded in a transaction log?

935

---

What is spid in sql server profiler?

1025

---

Explain what is the purpose of sql profiler in sql server?

1004

---

Why do you need a sql server?

1027

---

How to list all triggers in the database with sys.triggers in ms sql server?

1010

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

984

---

Is mysql the same as sql server?

910

---

what does the automatic recovery do? : Sql server administration

958

---

Explain how you can deploy an SSRS report?

135

---

What is a trigger what are the advantages of trigger?

912

---

What is the difference between for xml raw and for xml auto?

973

---

what is difference between NULL and ISNULL in SQL Server 2008?

964

---

What are the types of indexing?

1028

---

What is SQL Azure Federations?

112

---