Build a CRUD tool for Microsoft SQL Server fast

Jul 8, 2022

Written by

Arisa Amano

Building CRUD apps has never been easier.

‍

With Internal, you can connect SQL Server and build CRUD apps in minutes—to create, read, update, and delete data. Internal comes out-of-the-box with everything you need to build great CRUD apps for SQL Server including components (e.g. tables, buttons, forms), CRUD Functions, and granular permissions.

Out-of-the-Box Components for SQL Server

Internal provides a variety of components that you can simply drag and drop onto your Space to start designing your CRUD app. These components include tables, buttons, forms, dropdowns, images, CSV uploads, and more:

A screenshot of Internal, showing out-of-the-box CRUD components — *Some of Internal’s out-of-the-box CRUD app components*

‍

Internal’s app builder is easy to use, and doesn’t require SQL or code—although you can always use code and SQL if you want! Here’s what building a SQL Server CRUD app feels like with Internal:

CRUD Functions for SQL Server

As soon as you connect SQL Server, Internal automatically generates List, Get, Update, Insert, and Delete functions for each table in your database. These Functions can be used with Internal’s components to create a CRUD app quickly.

No need to write any SQL. All you have to do is choose a component (such as a table or a button) and a Function to display or modify data from SQL Server.

Custom CRUD Functions for SQL Server

If you want to join multiple tables or execute a more complex SQL operation, you can use Internal’s Function Editor to create a custom SQL Server Function. Internal supports creating several different types of custom SQL Server Functions:

A screenshot showing a dropdown of Internal's SQL Server CRUD actions — *SQL Server CRUD actions in Internal*

Select Functions

This type of function is used to read data from your SQL Server database. Enter a SQL query to create your function. When you create a Select function, Internal will automatically include filtering and pagination. You don't have to do anything else to configure that.

Insert, Update, Delete Functions

Use an Insert Function to create new records in a SQL Server database and an Update Function to update records in your SQL Server database. You’ll use Internal’s query builder to quickly create these custom Functions.

Raw SQL Exec

This type of function can be used to run custom insert, update, and delete queries as well as Stored Procedures in your SQL Server database.

Raw SQL Query

This type of function can be used to run custom queries that return data from your SQL Server database.

SQL Params

When you’re creating custom CRUD Functions for SQL Server, you can also add SQL Parameters to create variable inputs that can be used by your CRUD app. For SQL Server, you’ll use the syntax @name for any names parameter.

Custom SQL Parameters creating variable inputs

Granular Permissions for your SQL Server CRUD Apps

Internal comes out-of-the-box with field-level permissions that can be applied across all your SQL Server CRUD apps. For example, if you create a CRUD app for editing your database data, you can invite your IT manager and allow them to view and edit all fields. You can also invite your operations team and allow them to view and edit a subset of the fields in your CRUD app.

Additional Out of the Box Features for SQL Server CRUD Apps

Internal also comes with 2FA, Azure AD support, environments (e.g. staging and production), usage history, version history, and more. These features help keep your SQL Server data protected, allow you to test your app properly, and let you revert changes to the app as needed.

And if you aren’t an Internal customer, we invite you to sign up for an account and see what you can build!