Skip to content

Files

Latest commit

 

History

History

Scripts

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Recursion Examples
Recursion Examples
 
 
Ascii Values.sql
Ascii Values.sql
 
 
ColumnProperty.sql
ColumnProperty.sql
 
 
Create All Possible Objects.sql
Create All Possible Objects.sql
 
 
Cursor Example.sql
Cursor Example.sql
 
 
Data Profiling Table Count Babelfish.sql
Data Profiling Table Count Babelfish.sql
 
 
Data Profiling Table Count.sql
Data Profiling Table Count.sql
 
 
Determine Computed Columns.sql
Determine Computed Columns.sql
 
 
Drop Database.sql
Drop Database.sql
 
 
Global Variables.sql
Global Variables.sql
 
 
Grouping Keys.sql
Grouping Keys.sql
 
 
Merge Overlapping Time Periods.sql
Merge Overlapping Time Periods.sql
 
 
Merge Statement Example.sql
Merge Statement Example.sql
 
 
Missing Indexes.sql
Missing Indexes.sql
 
 
Random Numbers.sql
Random Numbers.sql
 
 
SQL Server Agent Job Steps.sql
SQL Server Agent Job Steps.sql
 
 
Second Highest Salary.sql
Second Highest Salary.sql
 
 
ServerProperties.sql
ServerProperties.sql
 
 
Sp_HelpText.sql
Sp_HelpText.sql
 
 
Stored Procedure Definition.sql
Stored Procedure Definition.sql
 
 
Table Column Names.sql
Table Column Names.sql
 
 
readme.md
readme.md
 
 

readme.md

Overview

Welcome to this GitHub repository, my go-to collection of SQL Server scripts that I have collected and saved to make life easier.

How to Use

Feel free to rummage around. I'm constantly adding and reorganizing this site, so if you cannot find anything, let me know, and I would be happy to help.

Notes

⌨️      All SQL is written in Microsoft SQL Server T-SQL, unless otherwise noted.

❓      If you have any questions, please feel free to create a GitHub discussion. I am always happy to help out and explain different solutions.

📫      If you find any inaccuracies, misspellings, bugs, dead links, etc., please report an issue! No detail is too small, and I appreciate all the help.

😄      Happy coding!

I hope you find this repository useful and informative, and I welcome any new puzzles or tips and tricks you may have. I also have a WordPress site where you can find my data analytics projects, Python puzzles, and blog.

https://advancedsqlpuzzles.com