Answer / arun anoop m

We use Self Join, if we have a table that references itself.


For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.

Working with TLogs

0 Answers  

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

What is cursors?

0 Answers   NA,

---

What is normalization and what are the advantages of it?

0 Answers  

---

How to download and install the scaled-down database adventureworkslt?

0 Answers  

---

List the advantages of using stored procedures?

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 is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

What is store procedure? When do you use?

0 Answers  

---