What are the properties and different types of sub-queries?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Explain about merge replications?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

Explain the first normal form(1nf)?

0 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---