Praveen Kumar's contributions

This article is based upon XML Elements, which are extensible and they have relationships. XML Elements have simple naming rules. XML documents can be extended to carry more information.

This article descritbes all basic details of XML and its relation with HTML

SQL Server architecture, transaction, ACID properties, isolation level, index, type of index, maximum, size, row,Active, Passive, SQL Server, lock, delete, truncate, OLAP, constraints,

The article is about Normalization, DeNormalization, one-to-one, one-to-many, many-to-many, Primary key, Unique key, User Defined Datatypes, Bit Datatype, Bit Column, Candidate Key, Alternate Key, Composite Key, Defaults.

This article contains Maximum Sizes/numbers.

Use of cursor, Nested transaction, Stored procedure, T-SQL, System function, Trigger and Selfjoin.

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.