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 is store procedure? When do you use?

984

---

How to list all user names in a database?

1090

---

Define Wed Edition in SQL Azure?

102

---

What is the osql utility?

1033

---

Explain some stored procedure creating best practices or guidelines?

1000

---

What is sharding?

116

---

How to create a trigger for insert only?

1083

---

What are different types of join?

1372

---

What is tcl in sql server?

1167

---

What happens if null values are involved in datetime operations?

1021

---

Explain difference between cross join and full outer join?

1063

---

Explain filtered indexes?

1039

---

Explain contrast amongst grouped and non-bunched records?

1087

---

What are synonyms?

1014

---

Explain primary key, foreign key and unique key?

1021

---