T-SQL Scripts

This repo includes a collection of T-SQL scripts which creates a database, creates tables in a database, and a variety of other functionality.

For Educational Purposes

This repo is designed to help individuals who are learning Microsoft SQL Server. Running the scripts sequentially will expose you to some powerful querying concepts available in SQL Server.

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
001-create-database.sql		001-create-database.sql
002-create-tables.sql		002-create-tables.sql
003-show-foreign-keys.sql		003-show-foreign-keys.sql
004-add-column.sql		004-add-column.sql
005-add-constraint.sql		005-add-constraint.sql
006-alter-column-data-type.sql		006-alter-column-data-type.sql
007-rename-column.sql		007-rename-column.sql
008-delete-column.sql		008-delete-column.sql
009-insert-people.sql		009-insert-people.sql
010-alter-table-with-default-value.sql		010-alter-table-with-default-value.sql
011-update-parents.sql		011-update-parents.sql
012-select-statements.sql		012-select-statements.sql
013-cte-hierarchy.sql		013-cte-hierarchy.sql
014-split-email.sql		014-split-email.sql
015-count-by-email-domain.sql		015-count-by-email-domain.sql
016-cte-paging.sql		016-cte-paging.sql
017-dynamic-sql-paging.sql		017-dynamic-sql-paging.sql
018-create-stored-procedure.sql		018-create-stored-procedure.sql
019-where-clause.sql		019-where-clause.sql
020-select-csv.sql		020-select-csv.sql
README.md		README.md

aaronwht/sql-queries

Folders and files

Latest commit

History

Repository files navigation

T-SQL Scripts

For Educational Purposes

About

Topics

Resources

Stars

Watchers

Forks

Languages