Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 155, comments - 2679, trackbacks - 64

My Links



Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.



Post Categories




December 2003 Blog Posts

Efficient paging of recordsets: SQL Server 2000

Here's the most efficient way that I can think of to return rows @a through @b from a table or query, when each row is ordered and can be uniquely identified by a set of columns, in SQL 2000.


posted @ Monday, December 22, 2003 12:31 PM | Feedback (35) | Filed Under [ T-SQL Paging Data Code Library - SQL ]

Create a Date in T-SQL

Another way to create dates easily, w/o using CONVERT or using a UDF (i.e., if you have SQL 7.0), if you are starting out with integers representing the year, month and day of the date you need to create:


posted @ Monday, December 15, 2003 10:07 AM | Feedback (6) | Filed Under [ T-SQL Code Library - SQL DateTime Data ]

Creating Dates and Date Math in T-SQL with a UDF

To me, this is a pretty handy function to have in your toolbox ...

posted @ Tuesday, December 09, 2003 10:50 AM | Feedback (27) | Filed Under [ T-SQL DateTime Data ]

Powered by:
Powered By Subtext Powered By ASP.NET