SQL Server

SQL server -T-SQL questions and examples.
Lessons once learned and now recorded.

No Picture
SQL Server

Update Field Based on a Field in Another Table

2025-12-13 Udar Gromov 1
This article contains 3 examples: – T-SQL; – MS Access; – AS/400.   This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from   UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one […]