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

2 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---