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

Explain throw statement in sql server 2008?

942

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

994

---

Can you explain what is sql server english query?

953

---

can you implement data mining in SSRS?

140

---

What is a subquery in a select query statement in ms sql server?

1076

---

Can you name some of the dml commands in sql?

969

---

How do I find sql server instance name?

921

---

Difference between uniqe index and uniqe constraint?

925

---

Do you know what is similarity and difference between truncate and delete in sql?

968

---

How to find table changes in sql server?

1059

---

System variable and temporary variables

2189

---

how to do partition in sqlserver

2418

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1154

---

What is a synonym for manipulation?

942

---

What is transaction server explicit transaction?

979

---