T-SQL Toolbox

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

sql文件使用記事本就可以打開,當然一些網(wǎng)站的編輯工具也可以打開;SQL為數(shù)據(jù)庫腳本文件，最好用數(shù)據(jù)庫的查詢分析器打開

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