如何在Visual Studio 2012中使用存储过程？ [英] How do I work with stored procedures in Visual Studio 2012?

问题描述

这可能会成为当天的愚蠢问题，但在编辑存储过程时，我很难在Visual Studio中找到工作流程。如果我想编辑存储过程，我可以在服务器资源管理器中右键单击它，并使我的编辑没有问题。但是，当我按CTRL-S再次保存时，对话框将转到我无法识别的库位置，并将存储过程文件的名称更改为 dbo.MyStoredProcedure.sql 。我可以轻松导航到另一个文件夹并更改名称，但它不记得我的更改，所以我每次都必须这样做，这是没用的。



我显然不按照它们应该使用的方式使用存储过程。有人可以提供任何建议吗？



亲切的愿望~Patrick

Hi,

This might turn out to be dumb question of the day, but I am struggling to find a workflow in Visual Studio when editing stored procedures. If I want to edit a stored procedure, I can right-click it in the Server Explorer and make my edits no problem. However, when I press CTRL-S to save it again, the dialog goes to a library location I don't recognise and changes the name of the stored procedure file to something of the form dbo.MyStoredProcedure.sql. I can easily navigate to a different folder and change the name, but it doesn't remember my changes, so I have to do this every time, which is useless.

I am obviously not working with stored procedures in the way they are supposed to be worked with. Can anyone offer any advice, please?

Kind wishes ~ Patrick

推荐答案

有一个小按钮向上箭头，在脚本上方名为Update

There is a small button with an arrow pointing up, called Update just above the script

这篇关于如何在Visual Studio 2012中使用存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！