SQL Script to append data to column"X"

[wfairban]

Currently I have column X in table A,B,C,D,etc. I need to append a "-E" on the end of all rows in Column X. What is the easiest way to do this?

 

[SQLDenis]

update table
set e = e + '-E'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

of course the e would be x

update table
set X = X + '-E'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

Look at FAQ183-4107. There is an undocumented procedure that lets you run upto three commands against every database or table. Just use the sp_MSForEachTable command. It should run a command something like:

UPDATE ?
SET x = x + '-E'

In MSForEachTable, the ? is replaced with each table name.

-SQLBill

Posting advice: FAQ481-4875

 

[SQLDenis]

Ok I see I misread the question
SQLBills suggestion is what you should use

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[wfairban]

Ok that worked great. Now I have another issue.

Spreadsheet has 2 columns: A = xnum and B = xnum + -E.
Database has a field in various tables called pnum. I need to update pnum with all xnum from column A = pnum in db then add -E on it.

I hope you are not as confused as I am..............