How to find SPID in SQL Server

SELECT @@SPID AS 'ID', SYSTEM_USER AS
      'Login Name', USER AS 'User Name'

Also ,
SELECT @@SPID

SQL Server Information

SELECT @@VERSION

SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
GO