What is an entity-relationship diagram (erd)?

0 Answers  

---

What are .mdf files?

0 Answers  

---

What are commit and rollback in sql?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 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 the maximum size of sql row in mssql?

1 Answers  

---

how to do partition in sqlserver

0 Answers   TCS,

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

What is save transaction and save point?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---