The SQL language returns different results based on the language.

1. You can use the language in SQL to set the language to be queried.

1.1 Use Traditional Chinese

As follows:Code:

 

View code 1 Set Language n ' Traditional Chinese '
2 Select
3 Datename (WW, ' 12:13:00 ' ),
4 Datename (DW, ' 13:12:00 ' ),
5 Convert (varchar, getdate (), 109 )

 

The execution result is as follows:

 

 

2.2 English

The Code is as follows:

View code 1 Set Language n ' English '
2 Select
3 Datename (WW, ' 12:13:00 ' ),
4 Datename (DW, ' 13:12:00 ' ),
5 Convert (varchar, getdate (), 109 )

 

 

 

3. For specific language, refer to the system table, SYS. syslanguages,