abstra-docs
Search…
abstra-docs
Introduction to Abstra
Changelog
Security
Accessibility
Tutorials
Getting started
Lessons
Documentation
Front-end
Back-end
Connectors
Code
Storage
Airtable
Google Sheets
DynamoDB
E-mail
GraphQL
Microsoft SQL Server
MongoDB
MySQL
PostgreSQL
REST APIs
REST v2
SSH
Telegram
Project Settings
Powered By
GitBook
Microsoft SQL Server
Configuration
Queries
You can write regular
SQL Server queries
here, for example:
1
SELECT * FROM "Users" u WHERE u.name LIKE '%John%'
Copied!
Passing parameters to the query
You can add
params
to your query by naming them
$variable
. When you use this query in the frontend, you can dinamically fill the parameters:
1
SELECT * FROM "Users" u WHERE u.name = $variable_name
Copied!
Insert example:
1
INSERT INTO "Users"(name, email) VALUES ($name,$email)
Copied!
Update example:
1
UPDATE "Users" SET name = $name WHERE u.email = $email
Copied!
Delete example:
1
DELETE FROM "Users" WHERE u.email = $email
Copied!
Previous
GraphQL
Next
MongoDB
Last modified
1yr ago
Copy link
Contents
Passing parameters to the query