Wednesday, 19 October 2016

// // Leave a Comment

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