DB/MsSQL

From Ever changing code

< DB

Revision as of 00:01, 24 January 2019 by Pio2pio (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID

SELECT @@SPID

Azure MsSQL

Due to architecture you cannot use USE statement.

References:

USE (Transact-SQL)
Use of USE in Azure SQL StackOverflow

Retrieved from ‘http://wiki.ciscolinux.co.uk/index.php?title=DB/MsSQL&oldid=3768’