Modify columns' name in batches

By hxd001_810, 2008/02/14

Total article views: 512 | Views in the last 30 days: 32

Rate this |

Join the discussion |

Briefcase

First,we find all tables which contain given column'name from current database.Lastly,we can
modify columns' name in batches by cursor mechanism.Please change @value variable into your value.

By hxd001_810, 2008/02/14

Total article views: 512 | Views in the last 30 days: 32

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

How to empty database

By Boka | Category: T-SQL

| 1,525 reads

Check owners, collations and backups

By paul_richardson | Category: Administration

| 864 reads

Truncate Table

By | Category: T-SQL

(not yet rated) | 3,946 reads

Combining Rows

By | Category: T-SQL

(not yet rated) | 3,111 reads

Like this? Try these...

Get dependant Objects

By BeoWulf . | Category: T-SQL

(not yet rated) | 571 reads

Get given character's position from a string

By hxd001_810 | Category: User Defined Function

| 716 reads

Generating permutations

By Rafal S. | Category: Miscellaneous

| 498 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com