sample11.sql

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

/* 文件名称: Sample11.sql */

DECLARE @number1 int
DECLARE @number2 int
DECLARE @number3 decimal(4,2)

SET @number1 = 13
SET @number2 = 5
SET @number3 = 3

SELECT @number1 + 10

SELECT @number2 - 10

SELECT @number1 + @number2

SELECT @number1 - @number2

SELECT @number1 * @number2

SELECT @number1 / @number2

SELECT @number1 / @number3

SELECT (@number1 * @number2) % (@number1 + @number2)