SQL Server FAST TRACK for Novices - Tables

Create a look up table in SQL Server Management Studio, define an auto-increment primary key, add name, description, and created date fields using getdate, and set visible and order.

Alter a table's schema in SSMS by adding and placing a comments field. Refresh to see changes and understand that existing data can influence adding or removing fields.

Master inserting records into a SQL Server table using direct inserts, table column defaults, and reusable scripts; build a stored procedure for inserts and practice with creation and sample scripts.

Learn how to insert records into a table using SSMS, populate the display field and rely on defaulted and auto number fields, and observe that missing descriptions remain empty.

Insert records into tables in SSMS while honoring not null fields and default values. Explore how not null constraints and schema changes affect inserts and require values to avoid errors.

Learn to insert records into a table when a not null field lacks value by using a default value like 'none', and recognize the difference between blank strings and nulls.

Execute a stored procedure to delete a single record from a table by passing the key value, then verify the removal with a before-and-after select.

Master inserting and updating records in the units table, using insert into with values or select, deleting with where, and updating with set clauses.

Use identity insert on and off to preserve auto number keys during inserts and deletes, preventing relationship corruption and avoiding disabling auto increment.

Learn how to script table creation and data insertion to streamline development and production workflows, including generating recreate-table scripts and a dynamic procedure that creates tables with prefixes and defaults.

Create tables efficiently with a base create table stored procedure. Pass the table name and a field-prefix to auto generate table scripts, including defaults and constraints.