How to insert multiple rows with a subquery?

0 Answers  

---

What is transaction server distributed transaction?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

---

What is the largest component inside a field?

0 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

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 difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

---