SQL查询中Parameters字段内的固定OwnerId能否设为变量？

Absolutely! Using a SQL variable for that fixed OwnerId is a smart move—it makes your query way easier to maintain, cuts down on repetition, and lowers the chance of typos if you ever need to update that ID later.

Here's how to modify your query to use a variable:

First, declare the variable at the start of your script (this works for SQL Server, which your query syntax suggests you're using):

-- Declare the fixed OwnerId as a reusable variable
DECLARE @FixedOwnerId VARCHAR(50) = '0C01C994-1205-E511-988E-26EE4189191B';

Then, update the [Parameters] field in your SELECT statement to reference this variable instead of the hardcoded ID:

SELECT 
    NEWID() as id, 
    'OwnerReassign' as name, 
    1 as TypeId, 
    'MyOrganisation' as OrgName, 
    '07DA8E53-74BD-459C-AF94-A037897A51E3' as SystemUserId, 
    0 as StatusId, 
    GETDATE() as CreatedAt, 
    '{"EntityName":"account","Ids":["'+CAST(AccountId as varchar(50))+'"],"OwnerId":"' + @FixedOwnerId + '"}' as [Parameters] 
FROM Account 
WHERE OwnerIdName IN ('John Smith') AND New_AccountType = 1;

Why this is better: #

• Easier updates: If you need to change the OwnerId later, you only have to edit it once in the variable declaration, not hunt through the JSON string.
• Clearer intent: Adding a comment to the variable makes it obvious what that ID is used for, which helps anyone reading the query later (including future you).
• Fewer mistakes: No more risk of mistyping the long GUID if you end up using it multiple times in a larger script.

You could even tweak the variable declaration to make its purpose extra clear:

-- Target OwnerId for account reassignment operations
DECLARE @FixedOwnerId VARCHAR(50) = '0C01C994-1205-E511-988E-26EE4189191B';

This change will work seamlessly with your existing query logic while making it more robust and easier to manage.

内容的提问来源于stack exchange，提问作者Ben