what is datawarehouse?

0 Answers   Informatica,

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

How you can get the list of largest tables in a database?

0 Answers  

---

What purpose does the model database server?

0 Answers  

---

What do you understand by coalesce in sql server?

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  

---

1 01 101 01010

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What is @@rowcount in sql?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---