T-SQL Toolbox

T-SQL Toolbox is a MS SQL Server database with a set of handy utilities for T-SQL database developers.

sql文件使用记事本就可以打开,当然一些网站的编辑工具也可以打开;SQL为数据库脚本文件，最好用数据库的查询分析器打开

Modules and Features

DateTimeUtil

A set of UDFs and configuration data for extended datetime handling, e. g. it offers easy timezone conversion incl. support for daylight saving times using native T-SQL (no CLRs).

The following UDFs are available right now:

UDF_ConvertLocalToLocalByTimezoneId

UDF_ConvertLocalToLocalByTimezoneIdentifier

UDF_ConvertLocalToUtcByTimezoneId

UDF_ConvertLocalToUtcByTimezoneIdentifier

UDF_ConvertUtcToLocalByTimezoneId

UDF_ConvertUtcToLocalByTimezoneIdentifier

UDF_GetFirstWeekdayInMonth

UDF_GetLastWeekdayInMonth

UDF_GetStartOfDay

UDF_GetEndOfDay

UDF_GetStartOfMonth

UDF_GetEndOfMonth

UDF_GetStartOfQuarter

UDF_GetEndOfQuarter

UDF_GetStartOfWeek

UDF_GetEndOfWeek

UDF_GetStartOfYear

UDF_GetEndOfYear