In my job I am being forced to use Microsoft SQL Server 6.5 as a database backend and I can't seem to find in it's select commands the functionality of MySQL's LIMIT. Limit in MySQL alows me to tell the database to return only x number of results starting at result number y. This is the perfect solution for spreading results over many pages through a result index and just about every search enging on the web does this and I have implemented it several times through MySQL. Now I am forced to use MS SQL server and the T-SQL SELECT doesn't have LIMIT! Help!
limiting MS Sql/transact sql queries
- Thread starter wxdqz
- Start date