New features in ScimoreDB v2.5

Two instatiation modes (in process/out of process)
Simplified usage and instantiation (2 calls Create(DBfolder)/Open(DBfolder)).
Database files are now movable, i.e. create on one location, copy to other place open and work with db or copy again to other place
Virtual paths for data files : embeddeddb.Open("test")– will create Test DB in location where .NET provider is installed

Round(x,d) - Rounds the argument x to d decimal places.
Floor(x) - Returns the largest integer value not greater than x.
Ceil(x) - Returns the smallest integer value not less than x.
Mod(n,m) or n%m - Modulo operation. Returns the remainder of n divided by m.
PATINDEX ( '%pattern%' , expression ) - Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found.
Scope_Identity() - Returns the last identity value inserted into an incremental column in the same SQL batch scope.
Last_Row(columnName) - Returns the last updated/inserted row's column value, where column name is: columnName or NULL if the last update/insert statement didnot affected any rows
AutoIdenity() - Return next identity value. The function used as Default value for the columns delcared in CREATE TABLE columns section. I.e. new row will automatically assing to the particular column next identity value.
T-SQL compatible syntax. Users, who has beed working with MS SQL Server, can easy jump to use ScimoreDB, since the SQL in ScimoreDB similiar to SQL Server.
CASE compatible statement.
IF - statement
WHILE,BREAK,CONTINUE - loop statements.
@@RowCount - Returns the number of rows affected by the last statement.
CREATE PROCEDURE compatible with T-SQL syntax
EXECUTE statement compatible with T-SQL
SELECT TOP x ... - Limit output to the first X rows.