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

Define full outer join?

955

---

What is a cache in ssrs?

134

---

What is policy based management (pbm)? : sql server database administration

985

---

How many partitions a clustered index has by default in sql server 2012?

1089

---

What is the purpose of sql profiler in sql server?

1020

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

---

How is sql used in sql server?

1008

---

What is transact-sql ddl trigger?

1106

---

What is the maximum size per database for sql server express?

1050

---

What is the difference between rank and dense_rank?

1085

---

What is the stored procedure?

1009

---

Can sql servers linked to other servers?

1041

---

What is the most common trace flags used with sql server?

1042

---

What is executereader?

952

---

What are the disadvantages of using the stored procedures?

1102

---