How to find sql version using cmd

Strange request...but doable.
Run SQLCMD in a command prompt:

SQLCMD -S MyComputer\MyServer

In my case, that would be:

SQLCMD -S GRIFFPC\SQLEXPRESS

When the server is connected, you will get a "1 >" prompt.
Enter:

select @@version
go

And press enter:

1> select @@version
2> go




--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
        Jun 17 2011 00:54:03
        Copyright (c) Microsoft Corporation
        Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64>
(Build 7601: Service Pack 1)



(1 rows affected)