AZR-SQL101 Date Language format in view

select format(GETDATE(),'dddd - dd - MMMM - yyyy','nl-NL')
--> dinsdag - 11 - september - 2018

select format(GETDATE(),'ddd - dd - MMM - yyyy','nl-NL')
--> di - 11 - sep - 2018

select format(GETDATE(),'dddd - dd - MMMM - yyyy','de-DE')
--> Dienstag - 11 - September - 2018

select format(GETDATE(),'ddd - dd - MMM - yyyy','de-DE')
--> Di - 11 - Sep - 2018

select format(GETDATE(),'dddd - dd - MMMM - yyyy','en-US')
--> Tuesday - 11 - September - 2018

select format(GETDATE(),'ddd - dd - MMM - yyyy','en-US')
--> Tue - 11 - Sep - 2018

Till Next Time

Reacties

Een reactie posten

Populaire posts van deze blog

AZR-SQL101 Linkend server from regular MS-SQL server to AZURE

USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'<<Friendly Name>>' , @srvproduct=N'' , @provider=N'sqlncli' , @datasrc=N'<<AzureSqlServerName>>.DATABASE.WINDOWS.NET' , @catalog=N'<<databasename>>' EXEC master.dbo.sp_addlinkedsrvlogin   @rmtsrvname=N'AZR_RSZK_STG' , @useself=N'False' , @locallogin=NULL , @rmtuser=N'<<LocalAccount>>' , @rmtpassword='<<VeryStrongPassword>>' Till Next Time
Meer lezen

AZR-SQL101 Create External Data Sources

DROP EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>]; CREATE EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>] WITH ( TYPE=RDBMS, LOCATION='<<SQL-ServerName>>.database.windows.net', DATABASE_NAME='<<DatabaseName>>', CREDENTIAL=  <<CrendentialName>> ); Till Next Time
Meer lezen

AZR-SQL101 Create Master Key

-- Drop master key IF EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') DROP MASTER KEY; -- Create master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<<ReallyStrongPassword>>'; GO Till Next Time
Meer lezen