Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Accurate Time Formatted Between Dates
SQL
10 years ago
database
datetime
functions
mssql
Aggregates excluding leaders in MySQL
SQL
12 years ago
aggregate
mysql
rank
Aggregates from bands of values in MySQL
SQL
12 years ago
data
mysql
query
statistics
Aggregates of specified size
SQL
12 years ago
aggregate
group
mysql
query
All X for which all Y are Z MySQL query
SQL
12 years ago
aggregate
mysql
query
Automatically Run Stored Procedure at Startup
SQL
6 years ago
dba
mssql
sp_procoption
startup
storedprocedures
Average the top 50% values per group
SQL
12 years ago
mysql
query
statistics
Avoiding repeat aggregation in MySQL
SQL
12 years ago
aggregate
mysql
query
Backup and Restore an Existing Database to a new Database
SQL
6 years ago
backup
dba
mssql
restore
Backup User Databases in SQL Server
SQL
6 years ago
backup
dba
mssql
Calculate Age Function
SQL
10 years ago
age
calculations
database
mssql
Calculate Time Between Two DateTime Fields
SQL
9 years ago
datetime
format
mssql
time
Capture SQL Server Execution Timings
SQL
5 years ago
benchmark
mssql
performance
query
sql
Change SQL Database Recovery Model to Simple
SQL
9 years ago
database
dba
mssql
recovery
Check if a Database Exists
SQL
8 years ago
dba
exists
mssql
Check if Date Occurs on Day of Week
SQL
3 years ago
date
datetime
day
functions
mssql
udf
utils
Check if Index Exists in SQL Server
SQL
6 years ago
dba
exists
index
mssql
table
Check if SQL Command Mode is Enabled
SQL
9 years ago
dba
mssql
sqlcmd
Check if Table or Column Already Exits
SQL
10 years ago
database
exists
mssql
Check Statistics Last Update Date
SQL
8 years ago
dba
mssql
statistics
1
2
3
4
5
6
»
Last
More »