SQL Azure - Using SQLCMD with SQL Azure | syntaxhelp.com

SQL Azure - Using SQLCMD with SQL Azure

Connecting to SQL Azure using SQLCMD

-- username: jacob
-- password: jacob123
-- server : tcp:urrg21kkk.ctp.database.windows.net

sqlcmd -Ujacob@urrg21kkk -Pjacob123 -Stcp:urrg21kkk.ctp.database.windows.net -dmaster

Connecting to SQL Azure and creating a Database

-- username: jacob
-- password: jacob123
-- server : tcp:urrg21kkk.ctp.database.windows.net
-- Database: Northpole

sqlcmd -Ujacob@urrg21kkk -Pjacob123 -Stcp:urrg21kkk.ctp.database.windows.net -dmaster
CREATE DATABASE NorthPole;
GO

Connecting to a SQL Azure Database and creating a Table

-- username: jacob
-- password: jacob123
-- server : tcp:urrg21kkk.ctp.database.windows.net
-- Database: Northpole
-- Tablename: Customers

sqlcmd -Ujacob@urrg21kkk -Pjacob123 -Stcp:urrg21kkk.ctp.database.windows.net -dNorthpole
CREATE TABLE Customers (CustID INT PRIMARY KEY, Name VARCHAR(20));

Share |

Cant find the page you are looking for?
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.

1056 reads