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