ALL
This keyword is used
with the asterisk "*" in a SELECT statement. By this
keyword you can select all fields from a table.
Syntax: The basic syntax of All is
below
SELECT ALL * FROM table_nam;
Example:
USE SQLCLR
GO
SELECT ALL * FROM Employee
GO
|
Id
|
Name
|
Age
|
Address
|
|
1
|
Alok Kumar Singh
|
30
|
IN
|
|
2
|
Tomas Paul
|
45
|
NZ
|
|
3
|
Cristomfer Dee
|
85
|
AU
|
|
4
|
Niel Macengi
|
55
|
US
|
No comments:
Post a comment