Update a table value on behalf of Database name
How to update tables value in a database , but condition is that you can perform updation on Database name ,in which table is present , you can not take table name for updation, and second condition is that updation is perform on all of table in database.
Hemant SrivastavaPosted Aug 2, 2012, 10:18 AM
We can get all the table names of a database (say Your_Db) as:
USE Your_Db
But not sure , how you will update a value in ALL the tables (means.. Is that column common in all the tables ?)SELECT * FROM sys.tables
Maby be it could help you..!