模擬演唱訂票搶購範例程式碼 - 使用預存程序

Demos used during my "When indexes are not enough" webinar for PASS Application Development Virtual Group

[Personal] Personal customize query build cross database during my service to automate redundant process and improve efficiency. *names are being altered (e.g. database-name, schema-name, etc.)

A repository for storing my some SQL exercises (sql-ex).

Containing the tasks from Softuni's course "DB Basics"

Project made in Microsoft SQL Server 2016 for my database course. Note some of the queries are solely made to show knowledge of the T-SQL language, not to be particularly efficent.

Projeto de um banco de dados T-SQL

This is a t-sql scripts repository. From complex to simple scripts. All reusable and multipurpose

T3ch Session: SQL Server Integration Service (SSIS)

使用 Transact-SQL MERGE 指令進行資料表同步並紀錄同步的結果

SQL queries and stored procedures(Procs), I've worked on on various projects.

School project

用兩張資料表的 join 結果更新指定資料表的欄位

Scripts that are useful for figuring out what is going on in a SQL server database

SQL Server vNext ERP Data Warehouse

database system for managing a small restaurant providing services to private clients as well as businesses

Database created with T-SQL and it's advanced features, focused on automating tasks.

(T-SQL) It's MERGE, simplified for common ETL

Blocked Process Report. Detailed explanation could be found on Red Gates SimpleTalk's link link 'Building a Custom Blocked Process Report' https://www.red-gate.com/simple-talk/sql/database-administration/building-custom-blocked-process-report/