Shulou(Shulou.com)05/31 Report--

This article shows you how to modify the logo column in SQL Server, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Through the interface design can be manually operated, can not achieve my batch modification of thousands of servers. Because of this, there is a script for batch execution. Environment: redgate + mssql 2008 R2 the following code is used with a little modification according to your own business. The copy code is as follows:-- allow updates to the system table exec sp_configure 'allow updates' 1 reconfigure with override GO-Unidentify column tag update syscolumns set colstat = 0 where id= object_id ('tablename') and colstat = 1 GO-insert row of id=8001-8003-restore identity column tag update syscolumns set colstat = 1 where id= object_id (' tablename') and name = 'identity column name'-reset initial value of identity DBCC CHECKIDENT (table name, RESEED, 10003)-prohibit updating of system tables exec sp_configure 'allow updates',0 reconfigure with override

There is also a lot of knowledge of batch operations, such as batch checking whether the length of the index is accurate, the length of the field is consistent, the job runs, the result is consistent, and the service starts at the same time. All need to be processed in batches. You can refer to my other articles for other methods of batch operation.

The above is how to modify the logo column in SQL Server. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.