27-updatebacktomcglynn.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 9 行

SQL
9
字号
DECLARE @ValueToUpdate VARCHAR(30)
SET @ValueToUpdate = 'McGlynn'
UPDATE CustomerDetails.Customers
   SET CustomerLastName = @ValueToUpdate,
       ClearedBalance = ClearedBalance + UnclearedBalance ,
       UnclearedBalance = 0
 WHERE CustomerLastName = 'Brodie'

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?