wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

What's the difference between a primary key and a unique key?

4 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

Can primary key be null?

0 Answers  

---

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

---

---

How is sql used in sql server?

0 Answers  

---

State the difference between union and union all?

0 Answers  

---

What is difference between rownum and rowid?

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  

---

What are the OS services that the SQL Server installation adds?

3 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---