Generate Scripts to Add Default Constraint to Column in Multiple Tables in SQL Server Database-P94.1

SQL Server / TSQL Tutorial Scenario:
You are working as SQL Server Developer, your company has the database with tons of tables. Each Table has some audit columns such as CreatedOn, CreatedBy. No default Constraints were ever created on them. You want to create the Default Constraint on CreatedOn Column for all the table with value getdate(), also you want to create Default Constraint for CreatedBy=SUSER_SNAME().
You may have another column of type string and you would like to generate scripts for that too.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)