analysis service tutorial
Автор: Sultan Sadiq
Загружено: 2018-11-16
Просмотров: 557
Описание:
VISUAL STUDIO 2015: (ye wala: Visual Studio Community 2015 with Update 3)
https://my.visualstudio.com/Downloads...
MICROSOFT SQL SERVER:
https://download.microsoft.com/downlo...
MICROSOFT SQL SERVER MANAGER:
https://download.microsoft.com/downlo...
SQL Server Data Tools (SSDT) for Visual Studio:
https://download.microsoft.com/downlo...
database link:
https://github.com/Microsoft/sql-serv...
SERVER INSTALLATION:
• Microsoft SQL Server 2017 Installation - S...
text for this tut
NT Service\MSSQLServerOLAPService
CASE
WHEN MiddleName IS NULL THEN
FirstName + ' ' + LastName
ELSE
FirstName + ' ' + MiddleName + ' ' + LastName
END
CASE ProductLine
WHEN 'M' THEN 'Mountain'
WHEN 'R' THEN 'Road'
WHEN 'S' THEN 'Accessory'
WHEN 'T' THEN 'Touring'
ELSE 'Components'
END
DATENAME(mm, FullDateAlternateKey) + ' ' +
DATENAME(dd, FullDateAlternateKey) + ', ' +
DATENAME(yy, FullDateAlternateKey)
EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
'Q' + CONVERT(CHAR (1), CalendarQuarter) +' '+ 'CY ' +
CONVERT(CHAR (4), CalendarYear)
CASE
WHEN CalendarSemester = 1 THEN 'H1' + ' ' + 'CY' + ' '
CONVERT(CHAR(4), CalendarYear)
ELSE
'H2' + ' ' + 'CY' + ' ' + CONVERT(CHAR(4), CalendarYear)
END
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: