What is b tree index?

0 Answers  

---

Wht is Stuff in sql ser

2 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  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

What is data block and how to define data block size?

0 Answers  

---

---

Explain partitioned view?

0 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

What are unicode character string data types in ms sql server?

0 Answers  

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

What is save transaction and save point?

0 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---