How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

Can you explain what is sql server english query?

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

---

What are secondary xml indexes?

0 Answers  

---

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 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 Self Join?

4 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---