Професионална програма
Loading...
tihomirj avatar 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

Тагове:
1
Databases Basics
todor.stamenov avatar todor.stamenov 16 Точки

Става и така:

CREATE VIEW V_EmployeeNameJobTitle AS 
SELECT CONCAT([FirstName] , ' ', [MiddleName] , ' ' , [LastName]) 
AS [Full Name], [JobTitle] FROM Employees
0
merchant avatar merchant 2 Точки

Здравейте,

всички варианти дават грешка в 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.

 

0
Bobby_Apostolov avatar Bobby_Apostolov 109 Точки

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

0