How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

What do you understand by replication in sql server?

0 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

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

4 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

what is datawarehouse?

0 Answers   Informatica,

---

Define Joins?

0 Answers   HCL,

---

How do I partition a table in sql server?

0 Answers  

---

List the different index configurations possible for a table?

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  

---

what is a deadlock? : Sql server database administration

0 Answers  

---