Answer / Lavi Sahu

"Cursors in SQL Server can have several disadvantages. They can lead to performance issues due to their iterative nature and can consume a lot of system resources. Cursors can also make the code more complex, harder to maintain, and less scalable. Additionally, cursors can sometimes result in poor query plan reuse, which can further impact performance."n

Differentiate between SQL and ORACLE joins and write their syntax.

1 Answers   Global Logic,

---

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 the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

what is a mixed extent? : Sql server administration

1 Answers  

---

What are the different methods available under sqlcommand class to access the data?

1 Answers   UGC Corporation,

---

Mention the 3 ways to get a count of the number of records in a table.

1 Answers  

---

Does the order of columns in update statements matter?

1 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

1 Answers  

---

what are the problems in logshipping?

3 Answers  

---

How do I perform an unattended install of sql server 2000?

1 Answers  

---

What are the functions in sql server?

1 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---