can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Explain what is cte (common table expression)?

0 Answers  

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

How can we remove orphan records from a table?

0 Answers  

---

What is dbcc?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---