LOB string splitter with ordinals in SQL Server 20169

sql-server-2016

Paul WhitePaul White

11This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`.

Paul White

SQL Server Assertion <simpletypes.cpp> stack dump when converting float to varchar with 128 style

sql-server-2014sql-server-2012

Anonymous 2530Anonymous 2530

14>1. what’s wrong with convert style 128?

Paul White

7This must be a bug with earlier versions of SQL Server. You can see it in action [with 2014 on db<>fiddle](https://dbfiddle.uk/um8qeyDl).

Jack Douglas

MS SQL solution for generating timeseries data16

sql-serverazure-sql-database

PaxPax

Query a Normalised Table Twice Without Using an Alias3

sql-server-2019

John K NJohn K N

11Not using an alias is a strange requirement, but *technically* yes.

Paul White

Using where in a json array in sql server

sql-server

kuskus

11One solution is below

PeterVandivier

Deadlock between online index rebuild and auto update stats

sql-server-2017

Anonymous 2148Anonymous 2148

Executions count reported by sp_QuickieStore 7

sql-server-2016

Anonymous 2148Anonymous 2148

9Hi there!

meme

sql server query error4

sql-server

Anonymous 2135Anonymous 2135

5This condition that compares `shour` with `datetime` is the problem:

ypercubeᵀᴹ

External verification of `SIGNBYCERT()` signatures from SQL Server 20163

sql-server-2016

NReilinghNReilingh

How do I write "proper" cursors?2

sql-server

Hannah VernonHannah Vernon

9`CURSOR_STATUS` provides a nice way of ensuring the cursor is ready and contains rows.

Hannah Vernon