Articles by Praveen Kumar

Database administration, RAID , improve performance, securing an SQL Server, deadlock , live lock, blocking, restart SQL Server, DBCC commands, database maintenance, statistics, moving data, databases, BACKUP, replicaion, service pack.

This article is based upon SQL Join (AND & OR). AND and OR join two or more conditions in a WHERE clause.

This article is based on Aggregate functions, these functions (like SUM) often need an added GROUP BY and HAVING functionality .

This article based on Drop and Truncate command.

This article belongs to the ALTER TABLE statement, which is used to add or drop columns in an existing table.

This article is based on the ORDER BY clause in SQL query, which is used to sort the result. The ORDER BY clause is used to sort the rows.

This article is very useful when u do not want to go into detail, it is a compact form of various useful SQL statement and its Syntax.

Order By statement is used to sort the rows in ascending or decending order according to column

This article is based on the SQL Aliases, these SQL aliases can be used for column names and table names.

This article is based on Joins and Keys in SQL query, which provides a relationship between two tables.

This article based on the SELECT INTO Statement. The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.

This article is based on Create statement, which is used to create a database.

This article is based on the UNION command, which is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type.

This article belongs to the IN operator in the SQL query, which may be used if you know the exact value you want to return for at least one of the columns.

Learn what a SQL view is and how it acts as a virtual table based on the result of a SELECT statement.

Learn about SQL built-in functions used for counting and performing calculations.

This article is based on BETWEEN ... AND operator in SQL query. The BETWEEN ... AND operator selects a range of data between two values. These values can be numbers, text, or dates.

This article is based upon the INSERT INTO Statement. Which is used to store or you can say a new row into the table.

This article based upon the WHERE clause, which is used to specify a selection criteria. This particular where clause can be used in select, insert and update statements.

This article belongs to DELETE statement, which is used to delete rows in a table.

Learn how the SQL UPDATE statement modifies existing data in a database table.

To fill a DataSet from multiple database tables, you fill different DataSet objects using different data adapters and call Merge method of DataSet.

The .Net DNS class can be used to get a host name or an IP of a given host name.

How do I hide a column in a DataGrid or DataTable?

This aticle shows how to call Oracle stored procedure from ASP.NET.