Sandeep Singh Shekhawat's contributions

In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement

In this article I am going to explain three jump statements; they are goto, break and continue.

In this I am going to explain instance constructors that are used to create an instance of a class and explain the different types of instance constructors

In this article, I am going to show how to sort an array by implementing the Bubble Sort In C#.

In this blog I am going to explain that how can do add, rename and drop a column from a table.

In this article I explain how to use enum, create an enum and get values from an enum with their enumeration list.

In this blog I am going to explain difference between VARCHAR and NVARCHAR.

In this blog I am explaining that how can reverse an integer number.

In this blog I am going to explain that how can get Maximum and Minimum integer number using user defined Scalar-valued functions in sql server 2008

In this article I am going to explain Command Line Arguments in C#.

This blog explains that what is use of ROWCOUNT.

In this article I am going to explain the Take and Skip operators in LINQ to SQL. The Take operator is used to return a given number of rows from a database table and the Skip operator skips over a specifed number of rows in a database table.

Learn how to use SUM, Average, Count, Max, and Min aggregate functions in LINQ to SQL and SQL Server, including grouped employee salary queries.

In this blog I am going to explain how can use group by clause. I have an EMPLOYEE table and want to sum of salaries as per employee name.

In this article, I am explaining how to get the last inserted identity value of an auto-increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT()). Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value that is produced in a single session; in other words, a connection while IDENT_CURRENT() returns the last identity value according to the table for any session.

In this article I am going to explain how to insert multiple rows using a user defined table type.

Explains how to swap two numbers without using third variable.

Learn how to implement custom paging in an ASP.NET GridView using a stored procedure, PageIndex, PageSize, and a Repeater-based pager to reduce unnecessary data retrieval.

In this blog I am going to explain that how can get comma (,) separate values from a column