What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

---

Some queries related to SQL

0 Answers   Motorola,

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is function of ROLLUP ?

0 Answers   HCL,

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

What are the steps you can take to avoid “deadlocks”?

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 are the differences between triggers and stored procedures?

0 Answers  

---