Precautions for renovating data table fields in ASP

xiaoxiao2021-03-06  65

The name of the data table and field can be modified via the ASP program, which can have certain modifications and maintenance on the table built.

SQL statement used: sp_rename 'Customers. [Contact Title],' Title ',' Column '

But when using, find a problem, when the name of the name is the same but the case is the difference in the field name:

15477 0 Note: Change any of the object names may destroy the script and stored procedures.

It seems that there is still a problem with the name of the name, I don't know if there is any solution. At this time, I have to change the word in the library.

转载请注明原文地址:https://www.9cbs.com/read-84217.html

New Post(0)