作者:廖盈秀怡伶 | 来源:互联网 | 2023-08-04 14:50
本文由编程笔记#小编为大家整理,主要介绍了markdown 自己的SQL Server评论公约相关的知识,希望对你有一定的参考价值。
> This is a way to comment and have ordered and legible my support code
--============================================================
-- RESPONSE & RESPONSEITEM CHANGE STATUS SCRIPT
--============================================================
INSERT INTO [dbo].[Table]
(
--ID - column value is auto-generated
Field1
)
-- Update & Select for Insert
-- ==========================
-- Response:
SELECT DISTINCT GETDATE(), 'mmm', 'Status Changed by request of user xxxx ticket xxxxx', r.rID, 0
--UPDATE r SET R.StatusID=1
-- ResponseItem: