MS-SQL alias

SQL alias

SQL aliases are used to temporarily rename a table or a column heading.
Select name as Person_Name, address as [Present Address] from person
Select name, address + ',' + city + ',' + postalcode + ',' + country as address from person
Select o.id, o.orderdate, p.name from person as p, order as o where p.id = o.id

Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions

SQL NULL Value

SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

SQL alias

AnkitWebLogic

Web Designing

Web Development

Programming