Tag: sql server

SQL Server 2008 doesn’t yet have the TRY_PARSE function, so safely converting text to […]

This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY.

If you’re working locally, building a new app from scratch, you might […]

Here’s my preferred syntax for a simple one-way readonly cursor: It uses […]

When you’re working through a cursor, if you need to update each […]

To make a column case-sensitive instead of the default case-insensitive, just add […]

Sometimes you just need to disable all constraints on a database. Maybe […]