DECLARE @SWIFTBalance NUMERIC = 0 DECLARE @BankAccountsId INT = 0 SELECT @BankAccountsId…
- 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
- 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.