ExecuteScalar Example in ASP.NET Using C# and VB.NET

Hi friends,in this article i will explain about ExecuteScalar Example in ASP.NET Using C# and VB.NET.
I already explained in the previous articles about How to Bind Nested Gridview from Database in asp.net with C#/VB.NET,Marquee tag or How to Scroll Text From left to right or How to Move the Text in HTML,C#/VB.NET:Save the generated pdf directly to the server directory folder without user prompt in ASP.NET and JQuery:How to Display Current Date and Time on Webpage using ASP.NET

JSON: Create Cascading DropDownList from Database using JQuery in MVC 4 Razor

Hi friends,in this article I will explain about JSON: Create Cascading DropDownList from Database using JQuery and Ajax in MVC 4 Razor.
In previous articles I already explained about How to Bind Data to DropDownList from Database using Stored Procedure in MVC 4 Razor,How to bind DropDownList from database in C# MVC 4 razor and How to Create Cascading DropDownList in MVC 4 Razor and JQuery.

MVC4 Razor:How to call Stored Procedure using C#

Hi friends,in this article I will explain about How to call Stored Procedure in MVC4 Razor.
I already explained in the previous articles about MVC4 Razor:How to retrieve view values on POST method in Controller using FormCollection,Mvc 4 Razor CRUD Operation using C# and How to create a dropdown list field for MVC4 Razor view?
Open SQL Server and write the below stored procedure and Execute.

SQL SERVER: How to find nth maximum value and nth minimum values in a column

Hi friends, in this article I will explain about  SQL SERVER: How to find nth maximum value and nth minimum values in a column.
I already explained in the previous articles about  How to Get Highest and Lowest Values in a Row using SQL SERVER, How to Display DateTime Formats in Different Languages using SQL Server and How to Calculate Age from Date Of Birth using SQL Server

How to Get Highest and Lowest Values in a Row using SQL SERVER

Hi friends, in this article I will explain about How to Get Highest and Lowest Values in a Row using SQL SERVER.

I already explained in the previous articles about How to Display DateTime Formats in Different Languages using SQL Server, How to Calculate Age from Date Of Birth using SQL Server and How to encrypt/decrypt string in sql server

How to Display DateTime Formats in Different Languages using SQL Server

Hi friends, in this article I will explain about How to Display DateTime Formats in Different Languages using SQL Server.
I already explained in the previous articles about How to Calculate Age from Date Of Birth using SQL Server, How to encrypt/decrypt string in sql server and How to get second-highest salary employees in a table,Find 2nd highest salary in SQL server, SQL Query for second maximum salary from employee table

You can get the list of languages support in SQL SERVER by using below Query

select * from sys.syslanguages

How to Calculate Age from Date Of Birth using SQL Server

Hi friends, in this article I will explain about How to Calculate Age from Date Of Birth using SQL Server
I already explained in the previous articles about How to get second-highest salary employees in a table,Find 2nd highest salary in SQL server, SQL Query for second maximum salary from employee table, How to encrypt/decrypt string in sql server and How to delete a null record in SQL Server or in SQL server how to delete rows where multiple columns have either null or Query to delete null or empty values from data table in SQL Server

How to encrypt/decrypt string in SQL Server

Hi friends,in this article I will explain about How to encrypt/decrypt string in SQL Server.
I already explained in the previous articles Split and convert Comma Separated String or any Delimited String to Table in SQL Server, Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance and How to List All Tables and Their Rowcount in SQL Server

How to get second-highest salary employees in a table,Find 2nd highest salary in SQL server, SQL Query for second maximum salary from employee table

                                         Hi friends, in this article I will explain about Find 2nd highest salary in SQL server, How to get second-highest salary employees in a table, SQL Query for second maximum salary from employee table.

In previous article i explained about  Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER,how to delete a null record in SQL Server or in SQL Server,differences between stored procedures and functions in SQL Server

I will explain the SQL Query for second maximum salary from employee table.

Create one table as Employee table

How to delete a null record in SQL Server or in SQL server how to delete rows where multiple columns have either null or Query to delete null or empty values from data table in SQL Server

Hi Friends, in this article I will explain about how to delete a null record in SQL Server or in SQL Server  how to delete rows where multiple columns have either null or Query to delete null or empty values from data table in SQL Server.

In previous article I explained some articles related SQL Server . Now I will explain about How to delete a null record in SQL Server. For that first create one table name it as USERS.

Differences between Stored Procedures and Functions | Stored Procedures vs Functions (Difference between SP & UDF)

                                Hi Friends, in this article I will explain about what is the differences between stored procedures and functions in SQL Server. In many interviews this question is compulsory.

                             I already explained in the previous article Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.

Difference between stored procedures and functions:

• Stored Procedure can return zero or n values whereas function can return 1 value.Function must return a value which is mandatory but in stored procedure it is optional. Procedure can   return multiple values (max 1024).

Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER

                                     Hi Friends, in this article I will explain about the Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.For many interviews this question is frequently asked.

First of all we know those individually after that we will know differences.

Truncate:

TRUNCATE Command  removes all the data or all rows from a table.
·         We cannot use where clause with Truncate command.
·         The operation cannot be rolled back and no triggers will be fired because it does not log individual rows.
·          As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
·         It frees the space containing the table.
·         Identity columns are re-seeded on this operation, if no seed was defined then the default value 1 is used.
·         This is a DDL command as its resets identity columns, deallocates data pages and empties them for use of other objects in the database.

Interview Questions and Answers on SQL SERVER Part II

                             Hi friends,in this article i will explain some interview questions on sql server,in previous article i already explained Interview Questions and Answers on SQL SERVER Part I,ASP.NET Interview Questions Part II | .NET interview Questions fot 1-2 years Experience

and  Interview Questions on .NET

ASP.NET Interview Questions Part II | .NET interview Questions fot 1-2 years Experience

                     Hi Friends, in this article I will explain about the some interview questions on ASP.NET.I already explained Interview Questions on SQL SERVER Part I | Interview Questions and Answers on SQL SERVER Part I ,Interview Questions in VB.NET, .NET Framework.,Interview Questions and ASP.NET interview Questions .

Windows Authentication to Access SQL Server Through a ASP.NET Web Application || Configuring SQL Server || Configuring IIS: || Configuring the ASP.NET Web Application || Creating Connection Strings

We need to configure the following four different areas to access Windows integrated security:

1.     SQL Server

2.     IIS Web Server

3.     ASP.Net web application

4.     ConnectionString

Interview Questions on SQL SERVER Part I | Interview Questions and Answers on SQL SERVER Part I

                  Hi Friends, in this article I will share some interview Questions on SQL SERVER.

I already explained some interview Questions on SQL SERVER in Interview Questions and Answers on SQL SERVER Part II

1.What is Sql server?

                SQL - Structured query language is the standard command set used to communicate with the relational database management system.