How to create a simple stored procedure in ms sql server?

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

How to access the deleted record of an event?

0 Answers  

---

What is sql stored procedure?

0 Answers  

---

Explain the storage models of OLAP?

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  

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---