DB/MsSQL - Revision history

Pio2pio: Pio2pio moved page MsSQL to DB/MsSQL without leaving a redirect

2022-03-11T15:44:02Z

Pio2pio moved page MsSQL to DB/MsSQL without leaving a redirect

← Older revision	Revision as of 17:44, 11 March 2022
(No difference)

Pio2pio at 13:39, 20 August 2021

2021-08-20T13:39:41Z

← Older revision		Revision as of 15:39, 20 August 2021
Line 1:		Line 1:
			= [https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools?view=sql-server-ver15 Install sqlcmd and bcp the SQL Server command-line tools on Linux] =
			<source lang=bash>
			# Import the public repository GPG keys.
			curl https://packages.microsoft.com/keys/microsoft.asc \| sudo apt-key add -
			# Register the Microsoft Ubuntu repository.
			curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list \| sudo tee /etc/apt/sources.list.d/msprod.list
			# Update the sources list and run the installation command with the unixODBC developer package.
			sudo apt-get update
			sudo apt-get install mssql-tools unixodbc-dev
			# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
			/opt/mssql-tools/bin/sqlcmd -?
			</source>


			= Operational commands =
	Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID		Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID
	<source lang=sql>		<source lang=sql>

Pio2pio: /* Azure MsSQL */

2021-08-20T13:31:49Z

Azure MsSQL

← Older revision		Revision as of 15:31, 20 August 2021
Line 7:		Line 7:
	Due to architecture you cannot use <code>USE</code> statement.		Due to architecture you cannot use <code>USE</code> statement.

	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/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]]

Pio2pio: /* Azure MsSQL */

2021-08-20T13:30:44Z

Azure MsSQL

← Older revision		Revision as of 15:30, 20 August 2021
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]]

Pio2pio at 22:01, 23 January 2019

2019-01-23T22:01:08Z

← Older revision		Revision as of 00:01, 24 January 2019
Line 4:		Line 4:
	</source>		</source>

			= Azure MsSQL =
			Due to architecture you cannot use <code>USE</code> statement.

			References:
			*[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
	[[Category:sql]][[Category:mssql]]		[[Category:sql]][[Category:mssql]]

Pio2pio at 21:58, 23 January 2019

2019-01-23T21:58:32Z

← Older revision		Revision as of 23:58, 23 January 2019
Line 3:		Line 3:
	SELECT @@SPID		SELECT @@SPID
	</source>		</source>

			[[Category:sql]][[Category:mssql]]

Pio2pio: Created page with "Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID SELECT @@SPID "

2019-01-23T21:57:34Z

Created page with "Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID <source lang=sql> SELECT @@SPID </source>"

New page

Show current session process ID. In Azure Data Studio, each query window has a different SessionProcessID
<source lang=sql>
SELECT @@SPID
</source>