Answer / Mohd Zaheer

SQL Server Procedures (also known as stored procedures) are precompiled prepared SQL code objects that can be created, altered, and dropped in a database. They can perform multiple SQL statements, have input and output parameters, and can return a result set.

Explain transaction server implicit?

1 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1 Answers  

---

How to select some specific rows from a table in ms sql server?

1 Answers  

---

What are the requirements for sql server 2016?

1 Answers  

---

What is sub-query in sql server?

1 Answers  

---

What are the results of running this script?

1 Answers  

---

What are exact numeric data types in ms sql server?

1 Answers  

---

Can we use where clause in union?

1 Answers  

---

What is clustered primary key?

1 Answers  

---

What is a trigger and types of a trigger?

1 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 importance of three tier architecture?

1 Answers   QuestPond,

---