if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Which is the latest version of sql server and when it is released?

0 Answers  

---

How to find index size for each index on table?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

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  

---

Define views.

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

How to delete exactly duplicate records from a table?

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---