Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Check if Date Occurs on Day of Week
SQL
2 years ago
date
datetime
day
functions
mssql
udf
utils
Determine Day of Week in SQL Server
SQL
2 years ago
date
day
functions
mssql
udf
Output the Results of a SQL Server Merge Statement
SQL
2 years ago
debug
examples
merge
mssql
Collapse Whitespace SQL Server Function
SQL
2 years ago
collapse
mssql
string
trim
udf
whitespace
Strip HTML Tags SQL Server Function
SQL
2 years ago
html
mssql
strip
tags
udf
Decode HTML SQL Server Function
SQL
2 years ago
decode
encode
functions
html
html-decode
mssql
udf
Trim and Uppercase String if not Null
SQL
3 years ago
mssql
string
trim
udf
uppercase
SQL Server Functions to Strip Unwanted Characters
SQL
3 years ago
alpha
alphanumeric
character
functions
mssql
number
strip
udf
Capture SQL Server Execution Timings
SQL
3 years ago
benchmark
mssql
performance
query
sql
SQL Server Database Performance Analysis Script
SQL
3 years ago
analysis
dba
mssql
performance
storedprocedures
Show Table Names in SQL Server
SQL
3 years ago
catalog
database
dba
mssql
table
Check if Index Exists in SQL Server
SQL
4 years ago
dba
exists
index
mssql
table
Using Dynamic SQL in Stored Procedures
SQL
4 years ago
dynamic
examples
mssql
security
sqlinjection
storedprocedures
Copy a SQL Server Database to Another Environment
SQL
4 years ago
backup
copy
dba
environment
mssql
Backup User Databases in SQL Server
SQL
4 years ago
backup
dba
mssql
Shrink All Database Files in SQL Server
SQL
4 years ago
dba
mssql
shrink
Truncate All Transaction Logs in SQL Server
SQL
4 years ago
dba
log
mssql
transaction
Disable SQL Server Agent Jobs in Category
SQL
4 years ago
dba
disable
job
mssql
sp_update_job
sqlserveragent
Find Out Who Deleted Rows in SQL Server
SQL
4 years ago
audit
dba
delete
mssql
Get Epoch Time in SQL Server
SQL
4 years ago
date
datetime
epoch
mssql
time
timestamp
1
2
3
4
5
6
»
Last
More »