5 posts tagged as "sql"

Using browser SQLite’s LIMIT/OFFSET to page results with AJAX

Another post mostly for me. I spent some time tonight trying to solve a problem in a mobile/HTML 5 app I am building. I have two lists that pull data from a client-side database that could possibly contain many records. Rather than pull all the...


LINQ to SQL - How to Where in (value1,value2, ... valueN)

According to FeedBurner the count of my blog subscribers has been steadily decreasing the last couple of weeks. I can't blame those quitters because my posts have been few and far between. But for those of you beautiful and intelligent people with...


Things I learned this weekend

Wield Chkdsk sparingly Do not set large hard drives (and especially not two large hard drives) to run an error check (chkdsk) on next reboot if: * your PC only supports USB keyboards and * your PC's bios does not support "Legacy USB...


Creating a PDF with SQL Server Stored Procs (and nothing else)

I found this beauty today via Mike Gunderloy's Daily Grind: http://ryanfarley.com/blog/archive/2004/10/25/1127.aspx Nice. I will have to play around with this a bit. Could prove to be useful.


I didn't know Query Analyzer could do that!?!

Mike Gunderloy's Query Analyzer Tips and Tricks Clearly, I have been seriously under utilizing (and probably underestimating) my friend, Query Analyzer. Mike Gunderloy is my hero.