DB/MsSQL

From Ever changing code

< DB

Revision as of 15:30, 20 August 2021 by Pio2pio (talk | contribs) (→‎Azure MsSQL)

(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:

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