Posts

MYSQL data time conversion with datetime Offset in MSSQL Server

Post a Comment

Converting JSON Key-Value Pair Dataset into HTML

Post a Comment

Split a string based on Capital letters in a string

Post a Comment

Read any Json data into a table structure using Dynamic SQL and save time write long queries.

Post a Comment

Date range function

Post a Comment
Image

Split a string separated by a deliminator into a table

Post a Comment

Converts an array of string into a table.

Post a Comment

Find out which tables have data in a database

Post a Comment

Get the number of work days Mon to Friday from a start and end date

Post a Comment

Fix SQL database User accounts when doing a backup and restore.

Post a Comment

Script out EXISTING database mail profile's settings

Post a Comment