How do I Update the Records of Multiple Tables having Same Column Name in One Query

Published by: Tina (2/2/2009 4:26:23 PM)

I am trying to write one query or stored procedure that can update all the tables having the same column name. Is there a way to dynamically deduce who all the tables are having same column name and update the needed records in that. Please let me know asap.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

How can I change the data type from varchar to numeric >>

<< Data Compression in SQL Server 2008