Getting SQL Server Details

To Get Service Pack Of SQL Server

SELECT SERVERPROPERTY('productversion') as 'Version Number', SERVERPROPERTY ('productlevel') as 'Service Pack', SERVERPROPERTY ('edition') as 'Edition'

To Get bit version of SQL Server

SELECT @@VERSION