sqlcmd：协调 -W 和 -Y
我有一个 varchar(max) 类型的 SQL Server 字段。我有一个自动批处理过程，它使用 sqlcmd 从数据库中提取数据并将其转储到文本文件中。我们有超过 256 个字符的字段，除非我在 sqlcmd 调用中的标志中添加类似“-y 0”的内容，否则这些字段会被截断。
这为我提供了大于 256 个字符的字段的全文，但它也添加了大量的空格 - 字段被填充以使每个字段根据其数据类型尽可能大，本质上给了我巨大的文件有大量的填充物和浪费空间。
我可以通过将 -W 添加到我的 sqlcmd 标志来解决此问题，但这会给我一个错误，指出 -W 和 -y 不兼容。
以前有人遇到过这个问题吗？思考如何解决它？
I have a SQL Server field of type varchar(max). I have an automated batch process that uses sqlcmd to pull data from a database and dump it into a text file. We have fields with more than 256 characters in them, and these fields get cut off unless I add something like "-y 0" to the flags in the sqlcmd call.
This gives me the full text for fields larger than 256 characters, but it also adds a great deal of whitespace--the fields are padded to make each field as big as it could possibly be according to its data type, essentially given me huge files with lots of padding and waste space.
I could fix this by adding -W to my sqlcmd flags, but this gives me an error saying that -W and -y are incompatible.
Has anyone had this problem before? Thoughts on how to solve it?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你的最长值是多长？您可能会使用
能够处理最多 65535 个字符宽度的开关，但除此之外将无济于事。
How long is your longest value? You may get away with the switches
which will cope with a width of up to 65535 characters, but will not help you beyond that.