SQL Studio parses the sql entered and translates it into MSCRM api commands. A simplified form of sql and some functions are supported. The function signatures are modeled after SQL Server.

The following criteria is supported

• =
• !=
• >
• >=
• <
• <=
• like
• not like
• in
• not in

• SELECT
• UPDATE
• INSERT
• DELETE

• DECLARE
• SET

• IF
• WHILE

• WAITFOR
• PRINT

• ISNULL (value, value)
• TYPEOF (value)
• NEWID ()

• LEN (string)
• REVERSE (string)
• SUBSTRING (string, start, length)
• TRIM (string)
• LOWER (string)
• UPPER (string)
• LEFT (string, length)
• RIGHT (string, length)
• FORMAT (string, format)

• GETDATE ()
• GETUTCDATE ()
• DATEADD (datepart, length, datetime)
• DATEPART (datepart, datetime)
• YEAR (datetime)
• MONTH (datetime)
• DAY (datetime)

• ABS ( number )
• CEILING ( number )
• EXP ( number )
• FLOOR ( number )
• LOG ( number )
• POWER ( number, power )
• ROUND ( number, decimals )
• SQRT (number)