Answer / Harshit Arora

"There are several methods to enhance SSRS (SQL Server Reporting Services) reports:
1. Using report parameters to allow users to customize the report output.
2. Incorporating subreports or nested reports within other reports for more complex reporting needs.
3. Utilizing expressions and code to perform calculations, conditional formatting, and data manipulation.
4. Implementing drill-through reports to provide detailed information on specific report items."n

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

Explain syntax for dropping triggers?

1 Answers  

---

Why use “in” clause in sql server?

1 Answers  

---

What is an indexed view?

0 Answers  

---

Differentiate between a primary key and a unique key.

1 Answers  

---

How to generate create table script on an existing table in ms sql server?

1 Answers  

---

What is sql language?

1 Answers  

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

What is the difference between commit and rollback?

1 Answers  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

How is a full-text index updated?

1 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---