Category Archives: Scripts

Batch Script to Deploy Multiple SQL files (Version 2)

I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch files. Refer http://sql-articles.com/scripts/batch-script-to-deploy-multiple-sql-files/ for the older version in command prompt. Thanks for all the users and lot of comments for improvements. Continue reading Batch Script to Deploy Multiple SQL files (Version 2)

Identify Null Columns and Data Null Columns

I saw an interesting question in Facebook group. It’s all related to NULL values.. How to identify NULLable columns in a table and column with data as NULL. I thought of searching it in internet and pointing him to the link but I couldn’t get a reliable post to point it to the user so I finally wrote it. This script will just give you information about nullable columns in a table and whether the nullable column has null values. You can either scan NULL data or you can skip it. Continue reading Identify Null Columns and Data Null Columns