Home

SQL Keywords: ALL

 

Description

The ALL keyword is used in conjunction with the asterisk "*" in a SELECT statement to select all fields from a table or a query. The formula to use is:

SELECT ALL * FROM WhatObject;

Here is an example:

USE Exercise;
GO

SELECT ALL * FROM Employees;
GO

                

Home Copyright © 2009-2011 FunctionX.com