Why do we use stored procedures in sql server?

0 Answers  

---

Which database stores information about replication?

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What is a dbms wizard?

0 Answers  

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

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  

---

Describe triggers features and limitations?

0 Answers  

---

Explain about local stored procedure?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What happens if null values are involved in comparison operations?

0 Answers  

---

Do you know what are acid properties of transaction?

0 Answers  

---