SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...

SQL Server supports the `xml` data type, and developers can retrieve result sets including this type using standard behavior of the <xref:System.Data.SqlClient.SqlCommand> class. An `xml` column can ...

How do you retrieve a row based on values in the properties of a JSON object in a text column? This is where the next part of the SQL Server 2016 support for JSON comes into play.

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.

Adding a ulong property that maps to a rowversion column via value conversion fails: Defaults cannot be created on columns of data type timestamp.. This is because for ulong properties, the column is ...

When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you re… ...