如何在SQL Server Management Studio(SSMS)中对SQL查询进行注释

Question

我在SQL Server Management Studio(SSMS(中有3个SQL查询，如下所示-现在，我想对它们进行评论：

SELECT * 
FROM test.admin.store_category
SELECT * 
FROM test.admin.store_product
SELECT * 
FROM test.admin.store_user

有什么方法可以评论他们吗？

Answer 1

您可以使用带有&quot--&quot和带有"/*"的多行注释*/">如下所示：

-- single-line comments
-- SELECT * FROM test.admin.store_category
SELECT * FROM test.admin.store_product
-- SELECT * FROM test.admin.store_user

/* multi-line comments */
/*
SELECT * FROM test.admin.store_category
SELECT * FROM test.admin.store_product
*/
SELECT * FROM test.admin.store_user