What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

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 how to convert numeric expression data types using the convert() function??

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

what does the automatic recovery do? : Sql server administration

0 Answers  

---

What are subquery and its properties?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

what is blocking? : Sql server database administration

0 Answers  

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---