Re: Update query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

As long as the database supports batch commands then yes you can send
multiple commands to it. As far as the second question though - I'm not
sure I understand what you mean but I'll take a stab at it. Are you asking
if you can send an Update command to the database with a subquery/join that
references a different table? If so, then yes, you can do that as well and
AFAIK that's supported with any database that supports joins/subqueries.
"Hemang Shah" <hemang@xxxxxxxxxx> wrote in message
news:B4GdnQaMyaBbpp_eRVn-uw@xxxxxxxxxxxxx
> Hello Is it possible to update data in multiple tables in one query ?
>
> If not, is it possible to update in one table but for which the where
> clause has conditions on Joins and other table?
>
> Thanks
>
>


.

Relevant Pages

  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot pass NULL to SelectParameters?
    ... out which order to load in is very useful.If your database is not finished, ... commands, but falls apart in too many instances. ... IDENTITY to INSERT without the primary key and let it autogen. ... My TCATEGORY table does have one row where TCATEGORYPARENTID is null ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)