What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

How to get a list all databases on the sql server?

0 Answers  

---

what is the sql equivaent of the dataset relation object ?

0 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  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

Explain activity monitors

0 Answers  

---

What is a rownum?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---