我可以使用 REPLICATE 函数来做到这一点,但这涉及大量的转换:CAST(REPLICATE(CAST(CAST(0 AS tinyint) AS varbinary(max)), @size)AS varbinary(max))(它甚至不适合在线...)有没有更好的方法来做到这一点?EDIT:代码应该适用于 @size >8000.解决方案原始表单CAST(REPLICATE(CAST(CAST(0 AS tinyint) AS varbinary(max)), @size)AS varbinary(max))仍然最适合我的需求.What is the most elegant way to create a string of binary zeros, of type varbinary(max), if the length is specified at run time (e.g., in a stored procedure)?I could do it using the REPLICATE function, but this involves a lot of casting:CAST(REPLICATE(CAST(CAST(0 AS tinyint) AS varbinary(max)), @size) AS varbinary(max))(It doesn't even fit on the line...) Is there a better way to do this?EDIT: The code should work for @size > 8000. 解决方案 The original formCAST(REPLICATE(CAST(CAST(0 AS tinyint) AS varbinary(max)), @size) AS varbinary(max))still suits my needs best. 这篇关于创建一个由零组成的二进制字符串,长度可变的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-27 21:46