Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

How to set a database state to offline in ms sql server?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

Where cross join is used?

0 Answers  

---

What is a bit datatype?

0 Answers  

---

What structure can you implement for the database to speed up table reads?

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 to create database with physical files specified in ms sql server?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

How to verify the port number of the sql server?

0 Answers  

---