PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
Having a width shorter than the length of binary data breaks the binary data
Given the input below and a max width of 12
INSERT INTO [dbo.].[BinaryExample] (
[Name],
[Data]
)
VALUES (
'SmileyFace',
0x89504e470D0A1A0A0000000D49484452000000640000005C080600000098CB10940000200049444154789C95BD079464577536FADD5
)
this gets formatted into:
INSERT INTO
[dbo.].
[BinaryExample]
(
[Name]
,[Data]
)
VALUES (
'SmileyFace'
,0x
89504E470D0A1A0A0000000D49484452000000640000005C080600000098CB10940000200049444154789C95BD079464577536FADD5
)
validated against poorsql.com the following option and 1.6.16 of the .net command line