Comments indicate user-provided text. There are two different types of comments: the – comment and the /…/ comment. Comments can be inserted on a separate line, nested (– only) at the end of a SQL command line, or within a SQL statement. The comment is not evaluated by the server. Two hyphens (–) is the SQL-92 standard indicator for comments.
Beekeeper Studio Is A Free & Open Source SQL Server GUI
I’ve upgraded from SQL Server and it was a smooth change — Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai
Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.
Example
SELECT *
FROM table1 -- this is a comment
INNER JOIN table2 ON table1.c1 = table2.c1
/* this is another comment */
WHERE table1.c1 > 10
ORDER BY table1.c1
More SQL Server Articles
- 5 Top Free & Open Source SQL Server GUIs for 2026
- 5 Free SSMS Alternatives for 2026 (Open Source, Cross-Platform)
- SQL Server Joins Guide: Inner, Left, Right & Full Joins
- How to Uninstall SQL Server: A Step-by-Step Guide
- How to Create a JDBC SQL Server Connection String
- SQL Server Subtraction Operations
- How to Rename a Column in SQL Server | Easy Step-by-Step Tutorial
- SQL Server Express Edition: Features and Limitations
- SQL Server System Tables and Stored Procedures (SPs)
- Essential SQL Server Performance Counters Guide
- The 4 Pillars of SQL Server Performance: CPU, Memory, Disk I/O, & Cache Hit Ratios
- SQL Server Client Network Utility
- Convert Microsoft Access databases to SQL Server or MSDE
- System Tables and Stored Procedures - SQL Server
- Connecting to SQL Server 2005 and SQL Server Express
- SQL Server Administration
- SQL Server Development and T-SQL
- Understanding DDL triggers in SQL Server 2005
- How To Limit The Number Of Rows Returned In SQL Server
- Migrating changes made to SQL Server databases to production
- Longhorn, Vista to drop SQL Server 2000 and MSDE support
- SQL Server Express and MSDE
- Specified SQL Server not found
- Compare SQL Server 2005 Editions
- SQL Server Utility (SSEUtil) - Essential Features Guide
- Microsoft SQL Server Cursors
- SQL Server Performance Optimization Guide
- OPENROWSET: Import data into SQL Server tables
- View SQL Server Agent job history
- SQL Server 2005 Express: Express Manager, Management Studio, downloads, & limitations
- List available SQL Server instances on the network
- How many rows does your largest SQL Server table contain?
- Microsoft released SQL Server 2005 SP2 CTP
- Verify SQL Server and MSDE Installation
- SQL Server Performance Analysis: Key Monitoring Areas
- SOUNDEX() helps you find that last name
- Not associated with a trusted sql server connection
- xp_fixeddrives: Monitor SQL Server Disk Space Usage
- GO (SQL Server TSQL)
- Tuning tempdb For Better SQL Server Performance
- SSAS Tutorial: Building SQL Server Analysis Services Cubes
- SQL Server Data Manipulation Language (DML)
- SQL Server Data Types and Ranges
- Guide to SQL Server Backup Types and Recovery Options
- Advantages of SQL Server 64-bit Architecture
- sp_configure: Limit SQL Server memory usage
- Detect Duplicate Rows in a SQL Server Table
- DBCC CLEANTABLE: Reclaim space for dropped columns
- SQL Server Performance Optimization Tips
- Understanding VARCHAR(MAX) in SQL Server 2005 & 2008
- Understanding SQL Server Memory Internals & Cache
- Understanding SQL Server Blocking and Deadlocks
- How to Import CSV Data into SQL Server Tables with BULK INSERT
- How (Any Why) To Add Source Control To SQL Server
- How to Drop a Constraint in SQL Server
