影響返回的系統訊息與日期時間格式
1.system messages
SET LANGUAGE 繁體中文;
GO
返回:
已將語言設定變更為 繁體中文。
SET LANGUAGE us_english;
GO
返回:
Changed language setting to us_english.
2.date/time formats
DECLARE @Today DATETIME;
SET @Today = '12/5/2007 13:00:11';
SET LANGUAGE 繁體中文;
SELECT DATENAME(month, @Today) AS 'Month Name';
SET LANGUAGE us_english;
SELECT DATENAME(month, @Today) AS 'Month Name' ;
GO
返回:
十二月
返回:
December
查詢支援的語言
select * from sys.syslanguages
Reference:
SET LANGUAGE (Transact-SQL)
