SQL Server Management Studio SSMS 尝试“保存到文件” 而不是按 F5 执行
这种情况间歇性地发生,似乎与意外敲击按键有关。
有什么想法导致这个吗?
This happens intermittently and seems to be related to accidentally hitting a key.
Any ideas what causes this?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
如果您不小心按下 SSMS 工具栏中的“结果到文件”按钮,您也可能会陷入此模式(就像我一样)。 根据需要单击“结果到文本”或“结果到网格”,您将返回到通常的预期行为。
You can also get stuck in this mode (like I did) by accidentally pushing the "Results to File" button in the toolbar in SSMS. Click the "Results to Text" or "Results to Grid" as desired and you'll be back to your usual, expected behavior.
之前的答案不适用于我。 我的查询结果已设置为网格(CTRL+D)。
问题是,如果您使用的是 Microsoft ergo 键盘并且功能锁(通常位于 F12 右侧的键)未打开,则 F5 将显示默认打开文件对话框。
所以,另一个令人尴尬的决定是:保持 F 锁定! :)
在许多笔记本电脑上,没有专门的按键,但通常有一个等效的按键,例如对于戴尔笔记本电脑:Fn+Esc 或多合一媒体键盘:Fn+Caps Lock
Previous answer didn't apply to me. My query results were set to grid already (CTRL+D).
The issue is, if you're using a Microsoft ergo keyboard and the function lock (key to the right of F12 usually) is not on, then F5 will bring up an open file dialog by default.
So, yet another embarrassing resolution is: Keep F lock on! :)
On many laptops, there is no dedicated key for this, but often there is a keypress that will be equivalent, such as for dell laptops: Fn+Esc or the All in One Media Keyboard:Fn+Caps Lock
听起来您好像不小心从“结果到网格”的默认查询选项更改为“结果到文件”。 如果是这种情况,很容易修复:
尝试上述步骤之一后,按 F5 再次运行查询。
It sounds like you have accidentally changed from the default query option of "Results to Grid" to "Results to File". If that is the case it is easy to fix:
Once you have tried one of the steps above, run your query again by pressing F5.