编辑sql server 2012中的存储过程 [英] Edit Stored Procedure in sql server 2012

问题描述

大家好，我是.Net的新手。现在，我正在更新一个已经在.Net中托管和开发的网站。在这个项目中，它们是使用存储过程，BAL，DAL等。我想在数据库表中添加额外的字段。为此，我下载了sql server 2012并添加了两个字段，并将这两个字段添加到存储过程，但它们没有保存。当我试图保存时，他们在本地保存为sqlquery1.sql，sqlquery2.sql，sqlquery3.sql .....就像保存但我正在从远程位置编辑数据库。我不知道该怎么做....请帮帮我。

Hi Everybody, I am new to .Net. Now , I am updating one website which it is already hosted and developed in .Net. In this project, they are used stored procedures, BAL, DAL etc. I want to add extra fields to database table. For that, I downloaded sql server 2012 and added two fields and also these two fields to stored procedures but they are not saving. when i am trying to save, they are saving locally as sqlquery1.sql, sqlquery2.sql, sqlquery3.sql .....like that saving but i am editing database from remote place. I dont know what to do....please help me.

推荐答案

我想你必须禁用防止保存更改。



步骤：

1.转到菜单栏单击工具 - > 选项。

2.选择设计师根/标签。

3.然后取消选中防止需要重新创建表格的保存更改。

4.单击确定。



快速编辑设计表的步骤。 />


问候，

Alexander Andri

I think u must disable Prevent saving changes.

Step:
1. Go to Menubar click Tools --> Options.
2. Choose Designers Root/Tabs.
3. Then Uncheck Prevent saving changes that require table re-creation.
4. Click OK.

This Step for edit design table quickly.

Regards,
Alexander Andri

这篇关于编辑sql server 2012中的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！