To access the Freeform SQL Editor to edit a Freeform SQL report For steps to create a Transaction Services report, see the Advanced Reporting This option is not available for Intelligent Cubes. You can use XQuery statements to retrieve data from a web service.Ĭreate Transaction report: To create a Transaction Services report, which can be used to update data in your various data sources. While database instances commonly point to a relational database, you can also create Freeform SQL reports from database instances connecting to text files or Excel files.Ĭreate Freeform SQL report: To create a report using custom SQL statements.Ĭreate Freeform XQuery report: To create a report using custom XQuery statements. Under Show templates for the following objects, select the Report check box. The Object Template - General pane opens. In the Developer Preferences dialog box that opens, select the Object Template category. In MicroStrategy Developer, from the Tools menu, select Developer Preferences. If the New Grid dialog box does not open when you select Report, you must modify a MicroStrategy Developer setting. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. In MicroStrategy Developer, from the File menu, select New, and then choose Report. To access the Freeform SQL Editor for a new report If there is no database instance defined in the metadata, the Freeform SQL Editor cannot be loaded and a message is displayed.ĭatabase instances are available for selection only if they have been set up correctly for use with Freeform SQL (select Project Configuration, then Database instances, and select the check box for the database instance from the Database Instance list). You must have the Define Freeform SQL report and Create schema objects privileges to access and use the Freeform SQL Editor. You can access the Freeform SQL Editor in one of the following ways, depending on whether you are creating a new Freeform SQL report or editing an existing Freeform SQL report. RIGHT JOIN SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition 4.The Freeform SQL Editor is where you create and define your SQL statement to generate a Freeform SQL report. LEFT JOIN SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition 3. INNER JOIN SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition 2. How to delete stored procedure DROP PROCEDURE sp_name Joins 1. How to call Stored procedure CALL sp_name 3. Create a Stored Procedure CREATE PROCEDURE sp_name(p1 datatype)ĮND 2. Drop a Trigger DROP TRIGGER trigger_name Stored Procedures 1. Create a Trigger CREATE TRIGGER trigger_name trigger_time trigger_event Deleting a View DROP VIEW View_name Triggers 1. How to call view SELECT * FROM View_name 3. DROP INDEX DROP INDEX index_name ON table_name Views 1. CREATE INDEX CREATE INDEX index_name on table_name(column_name) ĬREATE UNIQUE INDEX index_name on table_name(column_name) 2. DELETE DELETE FROM table_name where condition Example DELETE from EMPLOYEE where empId='0001' Indexes 1. WHERE condition Example UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001' 4. Example SELECT * FROM EMPLOYEE where dept ='sales' 3. Example INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales') 2. INSERT INSERT INTO table_name (column1, column2, column3. COMMENT Single-Line Comments: -Line1 Multi-Line comments: /* Line1, RENAME RENAME TABLE table_name1 to new_table_name1 6. ALTER ALTER TABLE Table_name ADD column_name datatype Example INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales') 3. Supports many operating systems like Linux*,CentOS*, Solaris*,Ubuntu*,Windows*, MacOS*,FreeBSD* and others.High productivity as it uses stored procedures, triggers, views to write a highly productive code.Reliable, very fast and easy to use database server.Open-source relational database management systems.MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. It's one of the robust, feature-rich online editor and compiler for MySQL. Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free. INSERT INTO CUSTOMERS (cId, product, price) INSERT INTO PRODUCTS VALUES(4,"","",004) INSERT INTO PRODUCTS VALUES(3,"BOOK",5.20) INSERT INTO PRODUCTS VALUES(2,"PENCIL",2.20) INSERT INTO PRODUCTS VALUES(1,"PEN",1.20)
0 Comments
Leave a Reply. |