Answer / Aniruddh Dev Singh

I'm not entirely sure about your question. If you are referring to Business Intelligence (BI), it typically involves several languages such as SQL (Structured Query Language), MDX (Multidimensional Expressions), and DAX (Data Analysis Expressions) for querying data, along with scripting languages like Python or R for advanced analysis.

What are diverse clauses that form a part of sql?

1 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1 Answers  

---

How to integrate the ssrs reports in application?

1 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

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  

---

how you can get the list of largest tables in a database? : Sql server administration

1 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

Explain what is row_number function?

1 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

What is update locks?

1 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1 Answers  

---

What is the difference between insensitive and scroll cursor?

1 Answers  

---