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
- what is the difference between Text and String Data type in SQL Server
- Cannot start .aspx
- Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- Why my MS SQL Server 2005 DSN Connection is not Working