Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

What is filestream?

0 Answers  

---

What is the purpose of forms?

0 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

Explain about service Broker functions?

0 Answers  

---

---

What is indexed views? plz explain with example?

2 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

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 statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---