Version of database and more details for SQL Server.

It's a constant.

You can just select it like any other column, you don't need to supply table name.

Also, you can use insert, update statements or in functions.

SELECT @@version