News

Hosted on MSN3mon
SQL Functions for Encrypting and Decrypting Large text fields
In SQL I’m creating the following Functions First I’m having a look ... TextLength - @HandledLength END SELECT @OldChunkText = SUBSTRING(@Data, @HandledLength + 1, @NextPart ) SELECT @OldChunk ...
Ars Technica20y
T-SQL, order by substring?
Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...