VistaDB 6
VistaDB / What's New - Version 6.5 / Getting Started - What's New - Version 5.7
In This Topic
    Getting Started - What's New - Version 5.7
    In This Topic

    New Features in This Release

    TOP Option for DML Statements

    The SQL Engine now supports TOP with INSERT, UPDATE, and DELETE statements in the same way it is supported with SELECT.  For example,

    DELETE TOP (10) FROM dbo.Log_History
    WHERE Event_Date < '20180101'
    

    While you can use TOP with a delete the order of rows is undefined.  To incorporate an ORDER BY a subquery must be used (Consistent with T-SQL)

    DELETE FROM dbo.Log_History
    WHERE PK_Log_History_Id IN
    (SELECT TOP 10 PK_Log_History_Id 
    FROM dbo.Log_History 
    WHERE Event_Date < '20180101'
    ORDER BY Event_Date ASC) 
    

    This syntax was previously valid in VistaDB 5 (as it just uses a TOP in the subquery).

    Engine Time Functions

    The SQL Engine now supports SysDateTime(), SysUtcDateTime(), and SysDateTimeOffset() functions, needed for EF Core support. 

    Defects Fixed in This Release

    Engine

    Data Migration Wizard

     

    See Also