Anil Singh | Code-sample.com

Hello everyone, I am going to share the query to update a table using JOIN and without in SQL Server.             Table of Contents. 1.        Query for update a table using INNER JOIN. 2.        Query for update a table without JOIN. The query detail as given below. Query for update a table using INNER JOIN. i.e. UPDATE UR SET UR . IsDeleted = 1      FROM [DBO] . [USERROLE] AS UR       INNER JOIN [DBO] . [USERS] AS U   ON UR . UserID = U . UserID WHERE UR . UserID = 1001         AND   U . UserID = 1001 Query for update a table without JOIN. i.e. UPDATE U   SET U . ISDELETED = 0 FROM [DBO] . [USERROLE] AS U WHERE U . USERID = 1023 For more detail go to link. http://blog.sqlauthority.com/2013/04/30/sql-serv...