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 command do we use to rename a database?

1070

---

What guidelines should be followed to help minimize deadlocks?

936

---

What are the built in functions in sql server?

976

---

How many triggers are possible per table?

1090

---

What is constraints and its types?

935

---

What is NOT NULL Constraint in sql server 2012?

982

---

Does partitioning improve performance sql server?

972

---

Do you know concepts and capabilities of sql server?

1054

---

How sql server executes a statement with nested subqueries?

1021

---

What is cross join in sql server joins?

1131

---

Explain the categories of stored procedure?

931

---

what is an index? : Sql server database administration

969

---

What is simple indexing method?

1014

---

Will sql server 2005 allow you to reduce the size of a column?

980

---

What is temporal data type?

909

---