How to quickly view standard reports with the ability to edit SQL

You can add a special SQL editor button and set the initial query text. 

When you click on the button, the editor window with the SQL data is loaded and you can view the results of the queries by clicking on the run button. 

This feature is available only to the system administrator of the system.

Markup: 

<a href="#" class="as-sp-link" data-type="query" data-control="" data-entity="" data-operation="" title="Log Changes"><i class="fa fa-database"></i> Changes Log
   <span class="as-sp-sql hide">
     SELECT TOP (100) [id],[typeCode],[itemID],[field],[value],[username],[created]
     FROM [Falcon].[dbo].[as_changeLog]
     order by id desc
   </span>
</a>

Key points: 

  • data-type=query sets the editor mode of an arbitrary SQL query, not a separate SP procedure
  • the query itself is located in a child invisible element of as-sp-sql
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop yourself or collaborate with us for web development on the Falcon Space platform using only SQL and HTML.
View examples with SQL code
Platform documentation
Working on MS SQL Server
Note