|
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
|
