Category: SQL Server

SQL Server Reporting Services(SSRS) | An Introduction

Introduction: This article introduces what is SQL Server Reporting Services and how does it works in brief. An Introduction to SSRS SQL Server Reporting Services (SSRS) is a server-based report generating software system provided by Microsoft. It is a part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration … Continue reading SQL Server Reporting Services(SSRS) | An Introduction →

Report Server Configuration Manager Setup for SQL Server Reporting Services (SSRS)

This article will describe the simple steps to configure the Report Server. To build reports using SQL Server Reporting services firstly, you need to install SQL Server Reporting Services. There are two method to install it. 1 . Install it from SQL Server installation file while installing SQL Server 2. Download SQL Server Reporting Services … Continue reading Report Server Configuration Manager Setup for SQL Server Reporting Services (SSRS) →

SQL Server Interview Questions and Answers for Mid Level

1.Write the script to create Table. Answer: CREATE TABLE Test ( ID int, LastName varchar(255), FirstName varchar(255), Address varchar(100), ); 2. What is Primary Key Constraint? Answer: The PRIMARY KEY constraint uniquely identifies each record in a database table. It must contain unique values and must not contain null values. Most of the tables should … Continue reading SQL Server Interview Questions and Answers for Mid Level →

ASP.Net Interview Question and Answers for Mid Level

1. What are the asp.net page life cycle, name cycle? Answer: PreInit() Init() InitComplete() PreLoad() Load() LoadComplete PreRender() Render() Unload() 2. What are the different Types of ASP.Net Validation Controls? Answer: RequireFieldValidator: validates for require filed or user input RangeValidator: it validates the range of input filed like (0-9), (A-Z), (100-2000) CompareValidator: it is used to compare … Continue reading ASP.Net Interview Question and Answers for Mid Level →