T-SQL query to copy data from one database to another database

T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in both Source and Destination DB.

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

Function to pad Bigint with leading zeros or other single characters

Function to pad bigint with leading 0's or other single character

Generic trigger for maintaining the Audit Log

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

List Extended Database properties for all databases

I am using database properties to add some useful information for each database. Tired of exploring each database from the menu in SSMS to look for specific information, I decided to make a script listing the extended properties for all my databases. I am pleased to offer this to the community 🙂

WorkDay Functions

Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.

Compare data of two tables

Script to facilitate the comparison of data between two SQL Server tables

A DateRange Table Valued function

The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.

ErrorHandling for running or deploying code

Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.