SQL – Step By Step Installation of SQL Server 2008

Step by step installation of Microsoft SQL server 2008.
read more | digg story

Read Full Post »

SQL – Cursors

IntroductionIn a relational database, operations are carried out on a complete set of rows in a table. The SELECT statement returns all the rows that satisfy the condition in the WHERE clause of the statement. This complete set of rows that the SELECT statement returns is called a ResultSet.Some applications cannot work effectively with the [...]

Read Full Post »

SQL – Using "UNION ALL" to Convert Horizontal Data to Vertical Data

Introduction
Hi, today I am writing a trick which I found while solving my friends problem in SQL. May be you people already aware with this trick but it’s new for me, so I am sharing it with you. Yesterday my friend asked me a problem in SQL, he wants to convert the horizontal data to [...]

Read Full Post »

SQL – Truncate and Delete

Introduction
Hi to all, here I am with a new article; topic of this article is “Difference between Truncate and Delete”.

Truncate an Delete both are used to delete data from the table. These both the command will only delete the data of the specified table, they cannot remove the whole table data along with its structure. [...]

Read Full Post »

SQL – Derived Tables

Introduction
With SQL Server you have the ability to create derived tables on the fly and then use these derived tables within your query. In very basic terms, a derived table is a virtual table that’s calculated on the fly from a select statement.
In concept this is similar to creating a temporary table and then using [...]

Read Full Post »

SQL – Temporary Tables

Introduction
Temporary Tables are a great T-SQL feature that lets you store and process intermediate results by using the same selection, update, and join capabilities that you can use with typical SQL Server tables.
“In the early days when I used Access I used to create tables that I treated as temporary and then delete them whenever [...]

Read Full Post »