tag:blogger.com,1999:blog-9025736111713624877.post2739215017861872783..comments2023-11-09T22:36:41.805-08:00Comments on Random technical stuff: Guaranteeing order in viewsTa bu shi da yuhttp://www.blogger.com/profile/00750381951662588677noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9025736111713624877.post-81831698600384317492009-11-11T01:13:17.812-08:002009-11-11T01:13:17.812-08:00Really? I didn't realise that...
That might ...Really? I didn't realise that... <br /><br />That might have helped Jeff Modem :-)Ta bu shi da yuhttps://www.blogger.com/profile/00750381951662588677noreply@blogger.comtag:blogger.com,1999:blog-9025736111713624877.post-76712854778269817712009-11-10T18:28:27.473-08:002009-11-10T18:28:27.473-08:00I believe this is (currently) safe:
SELECT TOP (...I believe this is (currently) safe:<br /><br />SELECT TOP (9223372036854775807)<br /> xxx<br />FROM dbo.ExampleTable<br />ORDER BY<br /> xxx ASC;<br /><br />The big number there is the maximum BIGINT.<br /><br />PaulPaul Whitenoreply@blogger.com