Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft Corporation. It is a popular database management system that is widely used by businesses and organizations to store and manage their data. SQL Server is designed to work seamlessly with a variety of applications and development tools, providing users with a powerful and flexible data management solution.

SQL Server is known for its scalability, high availability, and robust security features. It can handle large amounts of data and support multiple users simultaneously. SQL Server also provides a wide range of advanced features, including business intelligence tools, data analysis, and reporting capabilities. With its powerful data management tools and advanced features, SQL Server is widely used by businesses and organizations to manage their data effectively and make informed decisions based on their data insights.

Connect to Microsoft SQL server in Openblocks

Step 1: Create new data sources > Select Microsoft SQL server, and fill in the fields.

Step 2: Create Microsoft SQL server queries. Openblocks supports SQL mode and GUI mode. Select the one that suits you best.

Step 3: Finish your query, select a trigger method, and display the query result.

Using Microsoft SQL server in Openblocks

CRUD operations

When connected to Microsoft SQL server in Openblocks, you can perform create, read, update, and delete operations. In SQL mode, you can insert queries. If you are not familiar with SQL syntax, then you can use GUI mode for the following operations:

• Insert

• Update

• Delete

• Bulk insert

• Bulk update

Access data

In both SQL and GUI modes, you can check the data structure in the data browser panel, and access query results via {{queryName.data}} anywhere in your app.

About Openblocks

Openblocks is an open-source low-code platform where you can find 50+ built-in components. It also offers excellent documentation to discuss technical details, present practical tutorials, and provide all the information you need know for building an app. On Openblocks, you can get connected to most databases and any API within clicks, design custom components, share apps with colleagues or customers, and more.Start your first app now and feel free to reach the vibrant community on Discord if you encounter any issue or would like to share an idea!