What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

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 is the default fill factor value?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

What is nonclustered index with included columns ?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---