I m试图改用sp_rename的栏目,但引自计算栏。 I m 得出以下错误:
表1 由于该物体参与强制要求,因此无法重新命名哥伦。
只要我能够知道(假设)计算一栏是参考的唯一地点。 我猜测,由于我从技术上获得的任何数据,我可以减少并重新计算计算计算一栏,但我不知道是否有更清洁的方法?
增 编
哲学
鉴于SSMS的错误完全相同,Im认为这种错误不会比放弃和重新计算计算一栏更好。
我已经这样做。
First you should open the table designer than change the computed column name from here right click on it and then click on generate change table script. copy the script and execute it.
它将重新命名该栏,而不丢失数据。
vimal lohani DBA | MCP(70-461)
I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management ...
What datatype is the most efficient to store a number such as 11.111. The numbers will have up 2 digits before the point and up to three after. Currently the column is a bigint , I am guessing that ...
是否需要在提瓜表之后更新表格统计数据,还是自动更新?
Ok, so I ve got a bit of a SQL and Powershell problem. There are 2 SQL scripts, one to setup 4 different global stored procedures. Another to execute them and manipulate data before returning it to PS ...
I add a column of type tinyint and being set to not allow nulls in a table and generate the change scripts. The table has data in it at this time. The script has code that creates a temp table and ...
I am currently working on a particularly complex use-case. Simplifying below :) First, a client record has a many-to-one relationship with a collection of services, that is, a single client may have ...
I have a particularly troublesome xml column to query data from. The schema is fixed by the Quebec Ministry of Revenue so "it is what it is" The important part of the query looks like this: with ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
