What is sql server english query?

0 Answers  

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

what is a transaction? : Sql server database administration

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

What is an index in a database?

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

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  

---