C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Column Aliases

Posted Date: 04 Mar 2008 Resource Type: Code Snippets Category: SQL

Posted By: Ashwini Rupert Member Level: Diamond
Rating:

Points: 5

Column Aliases are used ti improve the readability of query and its output.
In SQL Server 2005, a column alias can be declared either before or after the
column designation in the SELECT statement


								
USE DATABASENAME
SELECT 
         COLUMNNAME1 AS ALIAS1,
         COLUMNNAME2 AS ALIAS2
FROM
         TABLENAME

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Tree view custmization with database --SQl2000
	Previous Resource: How to get the length of a string in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj