var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Equivalent in SQL server.
DB2 has syntax FETCH FIRST which can be used to get n number of rows and hence speed of queries. Anybody know what the equivalent is in SQLServer?
SELECT TOP 10 SalesOrderID, OrderDate FROM Sales.SalesOrderHeader
ORDER BY OrderDate DESC
Leave the ORDER BY out, if you want it to truly return records right away....
If you leave out the ORDER BY , don't you run the risk of not ensuring the same recordset is returned every time?
If someone adds a new sales order, you wouldn't get the same dataset either, correct?