how use sql server
USE master
GO
IF NOT EXISTS (
SELECT name
FROM sys.databases
WHERE name = N'TutorialDB'
)
CREATE DATABASE [TutorialDB]
GOhow use sql server
USE master
GO
IF NOT EXISTS (
SELECT name
FROM sys.databases
WHERE name = N'TutorialDB'
)
CREATE DATABASE [TutorialDB]
GOsql server setup commands
sudo systemctl stop mssql-server
42 sudo /opt/mssql/bin/mssql-conf set-sa-password
43 sudo systemctl start mssql-server
44 ls
45 sudo mssql -u sa
46 sqlcmd /S /d -U -P
47 sqlcmd
48 systemctl status mssql-server --no-pager
49 clear
50 sudo apt-get update
51 sudo apt install curl
52 curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
53 curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
54 sudo apt-get update
55 sudo apt-get install mssql-tools unixodbc-dev
56 clear
57 sqlcmd -S localhost -U SA -P 'cummings@2021'
58 sudo apt-get update
59 sudo apt-get install mssql-tools
60 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
61 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
62 source ~/.bashrc
63 sqlcmd -S localhost -U SA -P 'cummings@2021'
64 clear
65 ls
66 sqlcmd -S localhost -U SA -P 'cummings@2021'
67 historyCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
