How do I create a partition table in sql server?

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 steps you will take to improve the performance of a poor performing query?

0 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

What is a view?

6 Answers  

---

---

What are constraints?

0 Answers  

---

What is a materialized view?

3 Answers  

---

What is a database in ms sql server?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---