Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

DECLARE @SWIFTBalance NUMERIC = 0 DECLARE @BankAccountsId INT = 0 SELECT @BankAccountsId…

  1. User

    DECLARE @SWIFTBalance NUMERIC = 0 DECLARE @BankAccountsId INT = 0

    SELECT @BankAccountsId GenelBilgiler, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL UNION ALL SELECT 'SwiftBalance:' + CONVERT(VARCHAR(50), @SWIFTBalance) GenelBilgiler, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL . Conversion failed when converting the varchar value 'SwiftBalance:0' to data type int. Hatasını düzelterek scripti tekrar yazar mısın

  2. Assistant

    DECLARE @SWIFTBalance NUMERIC(18,2) = 0 -- added precision and scale for numeric DECLARE @BankAccountsId INT = 0

    SELECT 'GenelBilgiler' = CAST(@BankAccountsId AS VARCHAR(50)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL UNION ALL SELECT 'SwiftBalance:' + CAST(@SWIFTBalance AS VARCHAR(50)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
    -- explicitly casted @SWIFTBalance to varchar for concatenation success.