updatedemo5.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: UpdateDemo5.sql */
USE 北风贸易
GO

DECLARE @Name nvarchar(12)
DECLARE @Salary money

SET @Name = '洪志豪'
SET @Salary = 45000

UPDATE IncomeOverview
  SET @Name = '章立民',
         @Salary = 30000

SELECT @Name,@Salary