Get the time in Hour:Minute Format, or just the date, from a DATETIME with CONVERT styles 108 and 101, or with the TIME and DATE types in SQL Server 2008.
MIN and MAX Text: Collation Chooses the Extremes
MIN and MAX text use collation ordering, not numeric magnitude. Compare digit strings, empty text and NULL using an explicit BIN2 contract.
Date Conversion Styles: Disambiguate Day and Month
Date conversion styles define how incoming text becomes a date. Compare month-first and day-first interpretations without guessing. Keep invalid dates separate from missing input.
XQuery string-length: Count Content Without Markup
XQuery string-length counts the selected element string value. Seven bounded cases separate content from markup, empty elements from missing elements, and missing XML from existing documents.
geometry STBoundary: A Polygon Edge Is a Different Shape
geometry STBoundary returns the edge of a shape as another geometry instance. I inspect that result independently from the source. A polygon’s boundary is not another filled polygon with the same area.
SQL SERVER – Get Last Running Query Based on SPID
How to see the last running query of another session based on its SPID, using @@SPID to find session IDs and DBCC INPUTBUFFER to read the query.
Decimal Multiplication: Precision Can Reduce the Result Scale
Decimal Multiplication derives a result type from its operand types, and the precision limit can reduce the scale. I inspect three small products. A small numeric value does not necessarily imply a narrowly declared arithmetic result.