Tags » ASP. NET

IIS Error Message - An attempt was made to load a program with an incorrect format.

If you receive the following error message when running a website (usually after deploying onto a 64-bit machine):

Could not load file or assembly ‘PROJECTNAME’ or one of its dependencies. 150 more words


Sql Server interview

Explain various data region available in SSRS with their use.

Data regions are report items used to display data from a single dataset. You can perform grouping, sorting and various aggregate functions on data in data region. 5,968 more words


Top 20 SQL Interview Questions with Answers

What is the difference between inner and outer join? Explain with example.

Inner Join

Inner join is the most common type of Join which is used to combine the rows from two tables and create a result set containing only such records that are present in both the tables based on the joining condition (predicate). 1,975 more words


Sql server interview questions and answers

1. When is the UPDATE_STATISTICS command used?

- When the processing of large data is done, this command is used.
- Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. 8,030 more words


Types of Join in SQL Server

What is join??

An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.

There are many types of… 646 more words


SQL query to find second maximum salary of Employee

SQL query to find second maximum salary of Employee

In this section we will write SQL query to get second highest salary of Employee. Before writing query its good to be familiar with schema as well as data in table. 246 more words


Simple Way To Use Pivot In SQL Query


This is a very simple example of Pivot query for the beginners. We use pivot queries when we need to transform data from row-level to columnar data. 198 more words