Microsoft SQL Server: Run your first query

Connections, SQL worksheets and query results

1. Install Nexo SQL Studio and open Connections Explorer.
2. Add a connection, select the database engine and enter a unique name.
3. Enter the engine-specific fields. Test the connection, resolve any inline errors, then save.
4. Open a SQL worksheet from the saved connection and run the example below.
5. Inspect the results. Use a disposable database for write examples and review commit/rollback behavior before changing production data.

SELECT DB_NAME() AS database_name, SUSER_SNAME() AS login_name;

SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME;

Before connecting

Use the SQL Server host, port, database and supported SQL-login credentials. Check encryption and certificate settings. Do not assume Windows integrated authentication, Microsoft Entra authentication or Azure SQL compatibility from SQL-login support alone.

Troubleshooting

Check the selected engine, host or file path, database name, account permissions and TLS requirements. Keep the connection editor open while correcting failed tests. Include the engine, server version, extension version and a sanitized error when requesting support; never include passwords or wallet secrets.

Next steps

• Connection guide
• Connections, SQL worksheets and query results
• Feature availability

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.