What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What is difference between view and materialized view?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

What is order of B+tree?

0 Answers   HCL,

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What are differences in between sql server 2012 and sql server 2016?

0 Answers  

---

Explain system rowset functions?

0 Answers  

---