База ответов ИНТУИТ

Программирование в Microsoft SQL Server 2000

<<- Назад к вопросам

SELECT TOP 7 CustID AS [ID], OrderID, SaleDate, ShipDate, DATEDIFF(Day, SaleDate, ShipDate) AS [DaysToShip]FROM SaleWHERE ShipDate IS NOT NULL
Данный сценарий определяет:

(Отметьте один правильный вариант ответа.)
Варианты ответа
отображение первых 7 строк запроса, в котором существуют 2 псевдонима(ID и DaysToShip) и вычисляемый столбец на основе функции DATEDIFF(Верный ответ)
отображение первых 7% строк запроса, в котором существуют 2 псевдонима(ID и DaysToShip) и вычисляемый столбец на основе функции DATEDIFF
отображение произвольных 7 строк запроса, в котором существуют 5 псевдонимов(ID, OrderID, SaleDate, ShipDate, DaysToShip) и вычисляемый столбец на основе функции DATEDIFF
Похожие вопросы
SELECT TOP 7 CustID AS [ID], OrderID, SaleDate, ShipDate, DATEDIFF(Day, SaleDate, ShipDate) AS [DaysToShip]FROM SaleWHERE ShipDate IS NOT NULL
Данный сценарий определяет: 
SELECT TOP 7 CustID AS [ID], OrderID, SaleDate, ShipDate, DATEDIFF(Day, SaleDate, ShipDate) AS [DaysToShip]FROM SaleWHERE ShipDate IS NOT NULL
Данный сценарий определяет: 
CREATE TRIGGER CustomerDelete   ON Customer   INSTEAD OF DELETE AS   SET NOCOUNT ON  IF ( EXISTS (    SELECT *    FROM DELETED JOIN Sale      ON DELETED.CustId =  Sale.CustId    WHERE DATEDIFF( DAY, SaleDate, CURRENT_TIMESTAMP ) <365 ) )   BEGIN    RAISERROR( 'One or more customers have recent sales', 16, 1)     RETURN  END  DELETE    FROM Sale WHERE CustId IN          ( SELECT CustId            FROM DELETED )   IF ( @@ERROR > 0 ) BEGIN     ROLLBACK    RAISERROR( 'Could not delete all old sales', 16, 2 )     RETURN   END  DELETE  FROM Customer WHERE CustId IN          ( SELECT CustId            FROM DELETED )IF ( @@ERROR > 0 ) BEGIN  ROLLBACK  RAISERROR( 'Could not delete all old customers', 16, 3 )  RETURNENDRETURN
Данный сценарий выполняет действия: 
CREATE TRIGGER CustomerDelete   ON Customer   INSTEAD OF DELETE AS   SET NOCOUNT ON  IF ( EXISTS (    SELECT *    FROM DELETED JOIN Sale      ON DELETED.CustId =  Sale.CustId    WHERE DATEDIFF( DAY, SaleDate, CURRENT_TIMESTAMP ) < 365 ) )   BEGIN    RAISERROR( 'One or more customers have recent sales', 16, 1)     RETURN  END  DELETE    FROM Sale WHERE CustId IN          ( SELECT CustId            FROM DELETED )   IF ( @@ERROR > 0 ) BEGIN     ROLLBACK    RAISERROR( 'Could not delete all old sales', 16, 2 )     RETURN   END  DELETE  FROM Customer WHERE CustId IN          ( SELECT CustId            FROM DELETED )IF ( @@ERROR > 0 ) BEGIN  ROLLBACK  RAISERROR( 'Could not delete all old customers', 16, 3 )  RETURNENDRETURN
Данный сценарий выполняет действия: 
CREATE TRIGGER CustomerDelete   ON Customer   INSTEAD OF DELETE AS   SET NOCOUNT ON  IF ( EXISTS (    SELECT *    FROM DELETED JOIN Sale      ON DELETED.CustId =  Sale.CustId    WHERE DATEDIFF( DAY, SaleDate, CURRENT_TIMESTAMP ) < 365 ) )   BEGIN    RAISERROR( 'One or more customers have recent sales', 16, 1)     RETURN  END  DELETE    FROM Sale WHERE CustId IN          ( SELECT CustId            FROM DELETED )   IF ( @@ERROR > 0 ) BEGIN     ROLLBACK    RAISERROR( 'Could not delete all old sales', 16, 2 )     RETURN   END  DELETE  FROM Customer WHERE CustId IN          ( SELECT CustId            FROM DELETED )IF ( @@ERROR > 0 ) BEGIN  ROLLBACK  RAISERROR( 'Could not delete all old customers', 16, 3 )  RETURNENDRETURN
Данный сценарий выполняет действия: 
CREATE FUNCTION CustWithDiscount   ( @MinDiscount DEC( 5, 3 ) )   RETURNS @CustWithDiscountTable TABLE (     ( CustID INT NOT NULL,      CustName CHAR( 30 ) NOT NULL,       CustDisc DEC( 5, 3 ) NULL,       PRIMARY KEY( CustID ) ) BEGIN  INSERT INTO @CustWithDiscountTable    SELECT CustId, Name, CAST( Discount AS VARCHAR( 7 ) )    FROM Customer    WHERE Discount >= @MinDiscount   RETURNEND
Данный сценарий выполняет действия: 
CREATE FUNCTION CustWithDiscount  ( @MinDiscount DEC( 5, 3 ) )   RETURNS @CustWithDiscountTable TABLE (     ( CustID INT NOT NULL,      CustName CHAR( 30 ) NOT NULL,       CustDisc DEC( 5, 3 ) NULL,       PRIMARY KEY( CustID ) ) BEGIN  INSERT INTO @CustWithDiscountTable    SELECT CustId, Name, CAST( Discount AS VARCHAR( 7 ) )    FROM Customer    WHERE Discount >= @MinDiscount   RETURNEND
Данный сценарий выполняет действия: 
CREATE FUNCTION CustWithDiscount   ( @MinDiscount DEC( 5, 3 ) )   RETURNS @CustWithDiscountTable TABLE (     ( CustID INT NOT NULL,      CustName CHAR( 30 ) NOT NULL,       CustDisc DEC( 5, 3 ) NULL,       PRIMARY KEY( CustID ) ) BEGIN  INSERT INTO @CustWithDiscountTable    SELECT CustId, Name, CAST( Discount AS VARCHAR( 7 ) )    FROM Customer    WHERE Discount >= @MinDiscount   RETURNEND
Данный сценарий выполняет действия: 
CREATE PROCEDURE GetCustDiscount   @CustId INT,   @Discount DEC( 5, 3 ) OUTPUTAS  SET @Discount =    ( SELECT Discount       FROM Customer       WHERE CustId = @CustId
Данный сценарий выполняет действия: 
CREATE PROCEDURE GetCustDiscount   @CustId INT,   @Discount DEC( 5, 3 ) OUTPUTAS  SET @Discount =    ( SELECT Discount       FROM Customer       WHERE CustId = @CustId
Данный сценарий выполняет действия: