Random SQL Queries statements

I will be adding scripts or queries for future references that I sometimes have to use while working on SQL Server Management to interact with database,


Adding a new column to database table and populating value for records that are already there

Alter Table Table_Name Add Column_Name ColumnType

Go

Update Table_Name Column_Name = Value