How to compare the top two records using sql?

0 Answers  

---

What is an index in sql?

0 Answers  

---

What is shrink log file?

0 Answers  

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

What is self contained scalar sub query?

0 Answers  

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---

List the data types available in mssql?

0 Answers  

---

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  

---

How much memory that we are using in Logshipping Concept?

0 Answers  

---

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

4 Answers  

---