Get all records of a table by using TOP in select statement

As usual we use TOP keyword in our SQL statement for retrieving few records, but you can use TOP keyword to retrieve all data of a table by using "TOP 100 PERCENT" in your SQL statement.
Example:
SELECT TOP 100 PERCENT * FROM dbo.[EmployeeDetail]

Comments

Archive

Contact Form

Send