4 docs tagged with "UPDATE"

SQL Server: Solving a sreal-world scenario using the UPDATE statement in combination with JOIN and WHERE clauses.

SQL Server: Leveraging the power of the UPDATE statement's OUTPUT clause to effectively track and manage data modifications. Dive into real-world examples demonstrating how to capture and preserve altered data into a regular table, temporary table, or table variable, gaining valuable insights into the before and after states of your records.

SQL Server: When performing UPDATE with JOIN, using common table expression (CTE) can be very intuitive

SQL Server: When using table aliases in an UPDATE statement, you assign shorter and more convenient names to tables, which can make the statement easier to read and write.