RSS feed

Can I Update 2 Tables Using Single SQL Query

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

NOV 6 2008

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.


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



You can use HTML tags here.
*Code: Please enter the sum of 5+2