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.
SELECT TOP 100 PERCENT * FROM dbo.[EmployeeDetail]

Post a Comment

* Please Don't Spam Here. All the Comments are Reviewed by Admin.