DEFAULT Date column value

For modifying an existing column in an existing table:

ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn

Changing Credential Password

Requires ALTER ANY CREDENTIAL permissions to be granted.
----------------------------
--changes the password.
ALTER CREDENTIAL WilliamBenson_wbenson007 WITH IDENTITY = 'wbenson007',
    SECRET = '123456789';
GO

--removes the password.
ALTER CREDENTIAL WilliamBenson_wbenson007 WITH IDENTITY = 'wbenson007';
GO

MS-Access TRANSFORM Pivot into SQL Server T-SQL

-- MS-Access code
-----------------------------------------------------------------------------------
TRANSFORM Avg(q_percent) AS 'AvgOfq_percent'
SELECT [GUID], cast(quality_date as datetime) AS 'quality_date'
FROM #temp
GROUP BY [Guid], cast(quality_date as datetime)
PIVOT [Assessment Type]


-- T-SQL conversion
----------------------------------------------------------------------------------
SELECT *
INTO #temp2
FROM
(
SELECT [GUID], cast(quality_date as datetime) AS 'quality_date', q_percent, [Assessment Type]
FROM #temp
) t
PIVOT
(
  AVG(q_percent)
  FOR [Assessment Type] IN ("HR Call Assessment 2015", "HR Quality Assessment", "HR Ticket Assessment")
) p

CREATE VIEW syntax

Important to remember that ORDER BY works below when TOP is used.
--------------------------------------------------------------------

USE [database]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].vw_name
as
SELECT TOP 10
[col1], [col2], ...
FROM dbo.[tblName]
GROUP BY [col1], [col2], ...
ORDER BY [col1], [col2], ...

GO