explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

How sql server enhances scalability of the database system?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

---

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  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is transaction server consistency?

0 Answers  

---

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

---

What languages bi uses to achieve the goal?

0 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---