what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

What is transaction server isolation?

0 Answers  

---

---

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---