Interview Questions Part-6 | What is @@ROWCOUNT in SQL | What is Difference between Commit and Rollback in SQL | What is Candidate key, alternate key and composite key in SQL | What are Isolation Levels in SQL | What is Lock Escalation in SQL Server

What is the Use of @@ROWCOUNT?

Returns the number of rows affected by the Query.

Ex:

UPDATE authors SET au_lname = 'Jones'

WHERE au_id = '999-888-7777'

IF @@ROWCOUNT = 0

print 'Warning: No rows were updated'

Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?

What is PRIMARY KEY Constraint in SQL Server?

Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)

Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server

What is the Difference between a HAVING clause and a WHERE clause in SQL Server? 

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query

Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server

What is an Index in SQL Server?

An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)

Interview Questions Part-2 | What are the Different Types of Triggers | What is a View | What is the Difference between a Function and a Stored Procedure | What are the Advantages of Using Stored Procedures in SQL Server

What are the Different Types of Triggers?

After triggers and Instead of triggers 

After triggers are the triggers which are raised before the transaction committed or postback.

Instead of triggers are used to update the database tables which are associated with view instead of updating the view directly.

Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server

What is Normalization? 

In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.There are three main normal forms, each with increasing levels of normalization:

SQL Server Indexes Tutorial | Different Types of Indexes in SQL Server | Difference between Clustered Indexes and Non-Clustered Indexes in SQL Server

Introduction:

Here I will explain about SQL Indexes and different types of indexes and advantages of indexes in SQL Server.

Description:

An index can be created in a table to increase the performance of application and we can get the data more quickly and efficiently. Let’s see an example to illustrate this point suppose now we are reading book in that I need to check the information for dbmanagement to get this information I need to search each page of the book because I don’t know in which page that word information exists it’s time taken process. Instead of reading the each page of book to get that particular word information if I check the index of book (Glossary) it is much quicker for us to get the pages which contains the information with dbmanagement word. By using second method we can save lot of time and we can get information in efficient way.

what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server

Introduction:

Here I will explain about what is stored procedure is and advantages and disadvantages of stored procedures in sql server

Description:

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure

SQL Union Operator | SQL Union ALL Operator | Difference between Union and Union ALL Operators in SQL |

Introduction:

Here I will explain about SQL UNION and UNION ALL operators and differences between UNION and UNION ALL in SQL Server

Description

Union Operators are used to combine the result of two or more select queries into single result set.

Primary key constraint in sql server, foreign key constraint, unique key constraint, not null, check constraint in SQL Server

Introduction:

Here I will explain primary key constraint in sql server, foreign key constraint in SQL sever, unique key constraint in sql server, not null constraint in sql server and check constraint in sql server.

Description:

A Constraint is a property that we can assign to column in table. By assigning constraint property on column we can prevent the users to enter inconsistent of data in columns. We can assign these Constraint properties during the time of creation of table (By Using CREATE TABLE statement) or during the time of changing the existing table structure (By Using ALTER TABLE statement).

how to bind generic list to gridview | Bind Database values to Generic list using asp.net | Binding custom generic class list to Gridview

Introduction

Here I will explain how to bind generic list to gridview and how to bind database values to generic list using asp.net.

Description:

In previous article I explained clearly about what is WCF and how we can use WCF in our applications. Now I will explain how to use Lists in our application to bind data to gridview and I will explain how to bind database values to generic list using asp.net. 

Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information

Introduction:

In this article I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in iis7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. Now I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in asp.net. 

Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.

Introduction:

In this article I will explain how to solve Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. Problem in asp.net.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion of coding I tried to run my application on my local system during that time I got error like 

how to consume (or) use wcf service in web application | how to consume (or) use wcf service in asp.net | wcf tutorial with examples for beginners

Introduction:

Here I will explain how to use or consume WCF (windows communication foundation) service in web application using asp.net.

Description:

In previous articles explained clearly what WCF (windows communication foundation) is and how to create and consume WCF service in c#(windows application) and I also explained clearly uses of WCF Service. Now in this article I will explain how to consume WCF service in web application.

There is no compatible TransportManager found for URI. This may because that you have used an absolute address which points outside of the virtual application

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration problem in IIS7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

The page you are requesting cannot be served because of the extension configuration problem in IIS7

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration problem in IIS7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutorial for Beginners

Introduction:

Here I will explain what WCF (windows communication foundation) is, uses of windows communication foundation and how to create and use windows communication foundation in c#.

Description:

In previous articles explained clearly what webservice is and how to create and consume webservice using asp.net . In another post I explained clearly what windows service is and how to create windows service and sample of windows service using c#. Now in this article I will explain about windows communication foundation. First we will see what a WCF (window communication foundation) is and uses of WCF (windows communication foundation) after that we will see how to create and use WCF in c#.net.

The Service on local computer started and then stopped ,Some services stop automatically if there are not in use by other services or programs

Introduction:

Here I will explain how to solve the Service on local computer started and then stopped, some services stop automatically if there are not in use by other services or programs

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. In my system I tried to install windows service completion writing the code but at that time I was unable to install windows service I got error like this

how to delete windows service from system

Introduction:

Here I will explain how to delete windows service in our system.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. Now I will explain how to delete windows service in our system.

how to install windows service using command prompt or install/uninstall .NET windows service

Introduction:

Here I will explain how to install windows service and how to start the windows service in our local machine.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals. Now I will explain how to install windows service in our system.

To install windows service in your follow these steps