Search This Blog
Ms SQL server related technical issues and solutions to programming problems with SQL Server and linking to other services.
Posts
Split a string based on Capital letters in a string
- Get link
- X
- Other Apps
Read any Json data into a table structure using Dynamic SQL and save time write long queries.
- Get link
- X
- Other Apps
Split a string separated by a deliminator into a table
- Get link
- X
- Other Apps
Converts an array of string into a table.
- Get link
- X
- Other Apps
Find out which tables have data in a database
- Get link
- X
- Other Apps
Get the number of work days Mon to Friday from a start and end date
- Get link
- X
- Other Apps
Fix SQL database User accounts when doing a backup and restore.
- Get link
- X
- Other Apps
Script out EXISTING database mail profile's settings
- Get link
- X
- Other Apps
