Can primary key be a foreign key?

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

Can we write trigger for view?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

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

1 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 Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---