How to test a dml trigger in ms sql server?

0 Answers  

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

Define candidate key, alternate key, and composite key.

0 Answers  

---

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

What is the difference between a check constraint and a rule?

0 Answers  

---

What is data source in connection string?

0 Answers  

---

What is the purpose of the master database?

0 Answers  

---

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  

---

Explain about builtinadministrator?

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---