如何避免sqlcmd结果集之间出现空行?
参考我关于将 SQL 存储过程提取到 .sql 文件中的上一个问题 (参见此处) 我还有一个问题:
如何避免或删除结果集之间的sqlcmd空行?
原因(请参阅 MSDN) 当返回多个结果时,sqlcmd 会在批处理中的每个结果集之间打印一个空行。
这意味着存储过程(超过 4000 个字符)在 syscomments 中被分成两部分,如果使用 sqlcmd 导出到文本 (.sql) 文件中,则在此分割点处将出现一个新行。 如何去除或者避免呢?
Refering my last question on extracting SQL stored procedures into .sql files (see here) I have another question:
How to avoid or delete the sqlcmd blank line between result sets?
Reason (see MSDN)
When multiple results are returned, sqlcmd prints a blank line between each result set in a batch.
This means that stored procedures (longer than 4000 chars) are split into two parts each, in syscomments and if exported with sqlcmd into text (.sql) file there will be a new line at this split point. How to remove or avoid it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这是您的 批处理文件(它将适用于> 8000 个字符的限制,但很容易调整此限制):
我个人担心如此大的程序。
,但也有人认为大型程序不是问题:
here is update for your batch file (it will work for > 8000 chars limit but it's easy to tune up this limit):
personally I'm concerned about so large procedures.
but there are also thoughts that large procedures are not an issue: