List some case manipulation functions in sql?

0 Answers  

---

Explain trigger and its types?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

What is the maximum rows in sql server table?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

Define right outer join in sql server joins?

0 Answers  

---

Explain transaction server consistency?

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  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---