What is a primary index?

0 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---

Explain indexed view?

1 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

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  

---

How except clause is differs from not in clause?

0 Answers  

---

Explain about remote stored procedure?

0 Answers  

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

explain different types of joins? : Sql server database administration

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

Why SQL Agent is used?

0 Answers   Abacus,

---