To convert a datetime to a string in various formats in SQL Server, you can use the CONVERT(arg1, arg2, arg3) function, same like date to a string but with different format codes.

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.