4 posts tagged as "sql"

The referenced entity insert was modified during ddl execution

I ran into an issue recently when trying to create triggers for a table on a SQL Server database using node and the tedious library. I was using a promise to generate and execute the DDL to create each trigger and using Promise.all() to wait until…

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

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 settings” and you’ve…