With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

Prevent bad data in nchar, nvarchar, char, varchar columns via trigger or constraint - zgstumpf/sql-server-invalidstring ...

I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.The problem I'm running into is SQL Server exports NULL values as ...

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...