SQL Script Header - PHIntelligence/CodingStandards GitHub Wiki
/*************************************************************************************************************
**
** Object name : schema.ObjectName
**
** Compatability : Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)
**
** Documentation : N/A
**
** Benchmark timing : 6 mins
**
** Creation Date : 2019-05-10
**
** Creator : first.last
**
** Description : Summary of what the script is for
**
** Parameters : Input and output variables
**
** Used by : Any other objects that depend on this
**
** Modification Log
** Date Editor Description of Modification
** 2019-05-10 first.last Creation
*************************************************************************************************************/
To find out what version of SQL Server you are running:
PRINT(@@VERSION)
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)
Aug 19 2014 12:21:34
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)