What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

How to remove duplicate rows from table except one?

0 Answers  

---

What does COMMIT command do?

0 Answers   Amdocs,

---

What do you understand by replication in sql server?

0 Answers  

---

what is database replication? : Sql server database administration

0 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

Define full outer join?

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  

---

Will the writetext statement activate a trigger?

0 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---