Can I Update 2 Tables Using Single SQL Query

Published by: Riya (11/6/2008 10:21:28 PM)

I am using sql server 2005 as my database. I want to write a query where i will update 2 tables. Can I write a query to update both the tables in one connection? I read in many places and it seems that i have to use stored procedure to do this but i don’t want a stored procedure. If you know a trick or method to achieve this then let me know.

 

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 do I Restict Clients by IP Address to Access SQL Server 2005 >>

<< what is the difference between Text and String Data type in SQL Server