1.

Would You Store Your Query In A Ssrs Report Or A Database Server? State The Reason Why?

Answer»

Storing SQL QUERIES directly in text FORMAT in the dataset, should be avoided. Ideally it should be stored in a stored PROCEDURE in the database SERVER. The benefit is that the SQL would be in a compiled format in a SP and brings all the benefits of using an SP compared to using an ad-hoc query from the report.

Storing SQL queries directly in text format in the dataset, should be avoided. Ideally it should be stored in a stored procedure in the database server. The benefit is that the SQL would be in a compiled format in a SP and brings all the benefits of using an SP compared to using an ad-hoc query from the report.


Discussion

No Comment Found

Related InterviewSolutions