17. Create View Employees with Job Titles - НЕ РАБОТИ В JUDGE

tihomirj 33 Точки

17. Create View Employees with Job Titles - НЕ РАБОТИ В JUDGE

Колеги, моля за малко помощ за задача 17. Create View Employees with Job Titles от Exercise: Basic CRUD

При мен рабори (MS SQL Server MS), но JUDGE дава грешка

CREATE VIEW V_EmployeeNameJobTitle AS
SELECT FirstName+' '+
   CASE
       WHEN MiddleName IS NULL THEN LastName
       ELSE MiddleName+' '+LastName
   END
AS [Full Name], JobTitle FROM Employees

Тагове:

23/01/2017 22:35:21 Databases Basics

Виж всички отговори

todor.stamenov 16 Точки

Става и така:

CREATE VIEW V_EmployeeNameJobTitle AS
SELECT CONCAT([FirstName] , ' ', [MiddleName] , ' ' , [LastName])
AS [Full Name], [JobTitle] FROM Employees

24/01/2017 01:00:52

merchant 3 Точки

Здравейте,

всички варианти дават грешка в Judge:

MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file '...\a1a9da1a-d601-4515-a14e-3e42885eabb4.mdf'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

25/05/2020 14:22:13

Bobby_Apostolov 128 Точки

Здравей, имало е проблем с jude тогава, пробвай пак:)

03/06/2020 09:06:01

Виж всички отговори