Microsoft SQL Scripts Demo

This repo contains the following MS-SQL scripts demo:

AdventureWorks - SQL Query Demos

• The following MS-SQL script lists all employees with their name, job title, department, and corresponding highest total sales by year and month.

  Take a Look:

  Filename:

  AdventureWorks_list_employee_by_year_month_and_highest_total_sales.sql

• The following MS-SQL script ranks the top 5 product sales by year, month, and location.

  Take a Look:

  Filename:

  AdventureWorks_list_top_five_product_sales_by_territory_year_month.sql

Fibonacci Numbers Evaluator script

This MS-SQL script evaluates the Fibonacci sequence up to a number specified in the variable maxFibValue. This script will generate and display a sequence of consecutive numbers and in an adjacent column will indicate whether it is a Fibonacci number.

Take a Look:

Filename:

Fibonacci_Evaluator_script.sql

Result:

Palindrome Strings Evaluator script

This MS-SQL script evaluates which strings are Palindrome symbols from a list of strings provided in the script and generates and displays a list indicating in an adjacent column Palindrome Status which of them are Palindrome Strings.

Take a Look:

Filename:

Palindrome_Evaluator_script.sql

Result:

Getting Started

To run these scripts containing script variables (:setvar) in your SSMS environment, you should first enable SQLCMD Mode as shown in the following screenshot:

Important Note

Please note that even if some of these scripts generate their own databases, tables, temporary tables, and user-defined functions — and clean them up after execution — you should still run them in an isolated SQL Server environment.