Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Specifies the language environment for the session. The session language determines the datetime formats and system messages.
Transact-SQL syntax conventions
SET LANGUAGE { [ N ] 'language' | @language_var }
The name of the language as stored in sys.syslanguages. This argument can be either Unicode or DBCS converted to Unicode. To specify a language in Unicode, use N'<language>'
. If specified as a variable, the variable must be sysname.
The setting of SET LANGUAGE
is set at execute or run time and not at parse time.
SET LANGUAGE
implicitly sets the setting of SET DATEFORMAT.
Requires membership in the public role.
The following example sets the default language to Italian
, displays the month name, and then switches back to us_english
and displays the month name again.
DECLARE @Today DATETIME;
SET @Today = '2024-08-05';
SET LANGUAGE Italian;
SELECT DATENAME(month, @Today) AS 'Month Name';
SET LANGUAGE us_english;
SELECT DATENAME(month, @Today) AS 'Month Name';
GO
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniu