First steps with the sqlcmd utility

Log into the remote desktop vm-1.techcats.solutions

My login for this demo is tstudent but substitute your JagNetID (AU email before the @ sign) for tstudent

Double-click the SQL Server Cmd Line (sqlcmd) icon on the desktop; there is a similar icon labelled SQL Server Management Studio which leads a GUI for managing SQL Server. You can also start sqlcmd by typing sqlcmd in a command or PowerShell window.

SQL Server has been configured to use Windows authentication so your remote desktop login will auto-magically connect you to SQL Server

Note that SQL Server with its current security settings lets you see but not touch other databases

SELECT name, database_id, create_date  
FROM sys.databases
ORDER BY name;  
GO

Please prefix your database names with your JagNetID; SQL Server doesn't allow two or more DBs with the same name and all students will be creating, e.g., a TP00 database. This naming convention is not enforced by the current SQL Server security settings.

sqlcmd collects your SQL entries and submits them to the server when the GO command is entered.

My demo will create a database tstudentDemo and then create the share table from Watson Chapter 3

CREATE TABLE share (
  shrcode CHAR(3),
  shrfirm VARCHAR(20) NOT NULL,
  shrprice DECIMAL(6,2),
  shrqty DECIMAL(8),
  shrdiv DECIMAL(5,2),
  shrpe DECIMAL(2),
  PRIMARY KEY (shrcode));

INSERT INTO share
  (shrcode,shrfirm,shrprice,shrqty,shrdiv,shrpe)
  VALUES ('FC','Freedonia Copper',27.5,10529,1.84,16);

select substring(table_name,1,10) as TabName,
	substring(column_name,1,10) as ColName,
	substring(data_type,1,10) as ColType,
	substring(column_default,1,10) as DefValue,
	is_nullable from information_schema.columns;