Collections:
Defining and Using Table Alias Names in SQL Server
How To Define and Use Table Alias Names in SQL Server?
✍: FYIcenter.com
When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names. To define an alias for a table name, just enter the alias name right after the original table name in the FROM clause as shown in the following select statement:
SELECT l.id, l.url, r.comment FROM fyi_links l INNER JOIN fyi_rates r ON l.id = r.id GO id url comment 101 dev.fyicenter.com The best 102 dba.fyicenter.com Well done 103 sqa.fyicenter.com Thumbs up
⇒Using SELECT Statements with Joins and Subqueries in SQL Server
2016-10-30, 700👍, 0💬
Popular Posts:
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...