What are the types of stored procedures in an sql server?

0 Answers  

---

Explain about analysis services?

0 Answers  

---

How many triggers you can have on a table?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

Explain primary key and foreign key constraints?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

What is CTE in SQL

0 Answers   Infosys,

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---

Why I am getting this error when renaming a database in ms 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  

---