Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

Explain the xml support sql server extends?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

Why use identity in sql server?

0 Answers  

---

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

Explain the properties of the relational tables?

0 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---