Answer / divya

T-sql

Answer / suri

C and C++

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

What is the dbcc command and why is it used?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

What is an execution plan?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is data source in connection string?

0 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

When would you use it?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

How can delete duplicate records in cte in sql server?

0 Answers  

---