首页 \ 问答 \ 使用C＃更改SQL Server主键(Change SQL Server primary key using C#)

使用C＃更改SQL Server主键(Change SQL Server primary key using C#)

 我需要更改SQL Server表中的列类型。  
 我需要使用脚本或C＃来做。  
 原始数据类型是integer ，新类型是varchar(50) 。  
 我可以使用这个SQL脚本来做到这一点：  
ALTER TABLE confezionamento ALTER COLUMN partnumber varchar(50) 
 
 但问题是这个列是一组主键。  
 当我尝试执行时，发生错误，因为PK_CONFEZIONAMENTO正在使用该列。  
 如何在不访问SQL Server Management Studio的情况下执行此操作？ 

I need to change a column type in a SQL Server table.  
I need do it using a script or C#. 
The original datatype is integer and the new type is varchar(50). 
I can do it using this SQL script: 
ALTER TABLE confezionamento ALTER COLUMN partnumber varchar(50) 
 
but the problem is that this column is in a set of primary keys. 
When I try do execute, an error occurred because PK_CONFEZIONAMENTO is using the column. 
How I can do it without access to SQL Server Management Studio?

原文：https://stackoverflow.com/questions/29868873

更新时间：2022-10-11 22:10

最满意答案

 我想你可能会把ChangeSets和RevisionHistory混在一起。 如果您要跟踪Rally Artifact上的Revisions，您应该查看RevisionHistory集合。 Rally的源代码连接器使用ChangeSets将源代码提交与Rally中的各种工件相关联。  
 你可能会找到这个答案：  
 RevisionHistory和Revisions  
 有助于在SOAP中处理RevisionHistory。 该示例适用于用户故事，但同样适用于测试用例。  
 遗憾的是，您无法在RevisionHistory上进行查询，因此您需要检索可能与您的搜索匹配的所有测试用例，并对SOAP客户端中的TestCase创建者进行过滤。 您需要检查修订版0的作者属性：  
 0 Original revision 2013-Feb-18 09:23:11 AM America/Denver Sam Tester  
 并验证它符合您的标准。  
 只是一个单挑，特别是如果你刚刚开始构建集成，我强烈建议使用Rally的.NET REST SDK而不是SOAP。  
 REST更强大，性能更高，Webservices API 1.43是获得SOAP支持的最终API版本，而1.43在弃用之前大约需要9个月（截至2013年9月）。 Webservices 2.x仅支持REST，因此使用REST对于任何希望新Web服务功能向前发展的人来说都是必不可少的。 

I think you might be mixing up ChangeSets with RevisionHistory. If you're looking to track Revisions on a Rally Artifact, you should look at the RevisionHistory collection. ChangeSets are used by Rally's source code connectors to associate source code commits to various artifacts in Rally. 
You might find this answer: 
RevisionHistory and Revisions 
Instructive for dealing with RevisionHistory in SOAP. The example is for User Stories, but is equally applicable to Test Cases. 
Unfortunately, you can't query on RevisionHistory, so you would need to retrieve all the Test Cases that could potentially have matches against your search, and do the filtering for the TestCase creator in your SOAP client. You would need to check the Author attribute for Revision 0: 
0 Original revision 2013-Feb-18 09:23:11 AM America/Denver Sam Tester 
And verify that it matches your criteria. 
Just a heads-up, especially if you're just getting started with building your integration, I'd highly recommend using one of Rally's .NET REST SDK instead of SOAP. 
REST is more robust, more performant, and, Webservices API 1.43 was the final API release to have SOAP support, and 1.43 has about 9 months to go (as of 9/2013) before deprecation. Webservices 2.x is REST-only, so using REST will be essential to anyone wanting new Webservices features moving forward.

使用C＃更改SQL Server主键(Change SQL Server primary key using C#)

最满意答案

相关问答

SOAP Web服务，性能测试可能吗？(SOAP Web service, Performance test possible?)[2022-04-21]

在JBOSS 6.1.0上部署SOAP Web服务(Deploying SOAP web-service on JBOSS 6.1.0)[2022-10-06]

soap web服务响应非常慢(soap web service response very slow)[2023-05-10]

java web服务SOAP(java web service SOAP)[2022-05-22]

在负载测试的SOAP UI中，在测试用例中延迟触发Web服务请求(Trigger web service requests with delay in the test case in SOAP UI for Load testing)[2022-01-21]

SOAP Web服务Auth Headers问题(SOAP Web Service Auth Headers issue)[2023-11-07]

创建SOAP Web服务时不生成WSDL文件(WSDL file not generating while creating SOAP web service)[2022-05-15]

无法使用SOAP客户端访问AIF Web服务(Unable to access AIF web service using SOAP Client)[2022-09-29]

Joomla PHP SOAP Web服务(Joomla PHP SOAP web service)[2023-10-17]

Rally Web Soap服务 - 获取测试用例列表以及创建测试用例的人员(Rally Web Soap service - get a list of test cases and who created them)[2022-11-16]

相关文章

最新问答