Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Which database stores information about replication?

0 Answers  

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 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  

---

do views contain data ?

0 Answers   MCN Solutions,

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

What do you understand by the analysis services in sql server?

0 Answers  

---

Will the writetext statement activate a trigger?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

Where are stored procedures in sql server?

0 Answers  

---

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,

---