How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

How can you check the version of sql server?

0 Answers  

---

How to install sql server 2005 express edition?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

What do you understand by integration services in 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  

---

Can we create clustered index on composite key?

0 Answers  

---

How to use subqueries with the in operators in ms sql server?

0 Answers  

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---