help me Sql Experts

[Yuvatha]

Database lo column values update cheyyali.

 

suppose table 'xyz'  coumn 'abc' value 1000 unte i need to set that value to 2000.

 

Ila chala tables lo cheyyali..

 

any script to do this for entire database to find those columns and set value ?? or individual ga every table cheyala??

 

 

[teliyadu_nuvvu]

pm spider cheddy he will help

[Yuvatha]

pm spider cheddy he will help

thanks 

[Darshwana]

system sp use chesi get list of all tables in to table variable n loop thru n update...

 

column names etu different vundi vuntayi even if its the same column in diff tables.. if so... there is no easy way but to write update queries for each ... 

 

calling experts 

[Bairagi From Bapatla]

SELECT 'UPDATE ',name,' SET XYZ column=2000 WHERE XYZ column=1000' FROM sysobjects
WHERE Type='U'

 

vachina result set ni run chei

[Yuvatha]

system sp use chesi get list of all tables in to table variable n loop thru n update...

 

column names etu different vundi vuntayi even if its the same column in diff tables.. if so... there is no easy way but to write update queries for each ... 

 

calling experts 

i did that...anni update queries manager ki ivalante siggestundi 

[Yuvatha]

SELECT 'UPDATE ',name,' SET XYZ column=2000 WHERE XYZ column=1000' FROM sysobjects
WHERE Type='U'

 

vachina result set ni run chei

:3D_Smiles:  :3D_Smiles:

[agora]

[Bairagi From Bapatla]

:3D_Smiles:  :3D_Smiles:

but anni tables lo adhe column name undha?

[Bairagi From Bapatla]

also check this 

 

http://blog.sqlauthority.com/2013/06/04/sql-server-script-to-update-a-specific-column-in-entire-database/

[Yuvatha]

but anni tables lo adhe column name undha?

kaduga :(

 

 

each table has multiple columns with that data..

[Bairagi From Bapatla]

kaduga :(

 

 

each table has multiple columns with that data..

ha ha ala ayithe okko daniki okko update script rayalsinde...

[Yuvatha]

also check this 

 

http://blog.sqlauthority.com/2013/06/04/sql-server-script-to-update-a-specific-column-in-entire-database/

idi kuda one column in all tables ki example

[Yuvatha]

but anni tables lo adhe column name undha?

400 updates ivala :D

[Darshwana]

i did that...anni update queries manager ki ivalante siggestundi 

column names different vunte evaraithe em chesthar