Encrypt and Decrypt in SQL Server

T-SQL Columns, Tables Alias

In SQL, we can alias columns, views and tables. A table alias is also called a co-relation name.
It is a temporarily names of columns or tables.

The Alias temporarily assigns another name to a column, or table at the time of a SELECT query and the assigning alias doesn’t rename the column or table name actually!

Basically, it make column, or table more readable to the programmers.

Syntax:
--USE OF TABLE ALIAS
SELECT TBL.Id, TBL.Name 
    FROM [dbo].[Tbl_Demo] AS TBL
WHERE TBL.Id in (1, 2, 3) 

--USE OF COLUMN ALIAS
SELECT TBL.Id AS UID, TBL.Name AS UNAME
    FROM [dbo].[Tbl_Demo] AS TBL
WHERE TBL.Id in (1, 2, 3) 
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.