Collections:
Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server?
✍: FYIcenter.com
If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table "fyi_links":
SELECT id, created, url FROM fyi_links id created url 101 2006-04-30 dev.fyicenter.com 102 2007-05-19 dba.fyicenter.com 103 2007-05-19 sqa.fyicenter.com
2016-10-26, 971👍, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...