Difference between revisions of "DB/MsSQL"
< DB
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
References: | References: | ||
*[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15 Download and install Azure Data Studio] | |||
*[https://docs.microsoft.com/en-us/sql/t-sql/language-elements/use-transact-sql?view=sql-server-2017 USE (Transact-SQL)] | *[https://docs.microsoft.com/en-us/sql/t-sql/language-elements/use-transact-sql?view=sql-server-2017 USE (Transact-SQL)] | ||
*[https://social.msdn.microsoft.com/Forums/azure/en-US/1d83c593-095d-416b-b927-7a6489503131/sql-quotusequot-statement-is-not-supported-in-azure-sql-database-for-selecting-different?forum=ssdsgetstarted Use of USE in Azure SQL] StackOverflow | *[https://social.msdn.microsoft.com/Forums/azure/en-US/1d83c593-095d-416b-b927-7a6489503131/sql-quotusequot-statement-is-not-supported-in-azure-sql-database-for-selecting-different?forum=ssdsgetstarted Use of USE in Azure SQL] StackOverflow | ||
[[Category:sql]][[Category:mssql]] | [[Category:sql]][[Category:mssql]] |
Revision as of 15:30, 20 August 2021
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: