Which joins are sql server default?

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 are the indexes in sql server?

0 Answers  

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

List the different index configurations possible for a table?

0 Answers  

---

What are the different types of lock modes in sql server 2000?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

Why truncate is ddl?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---

How to create indexed view?

0 Answers  

---