1. You can assign values directly when you define a variable
DECLARE @Id int = 5
A 2.Insert statement inserts multiple rows of data at a time
INSERT into StateList VALUES (@Id, ' WA '), (@Id + 1, ' FL '), (@Id + 2, ' NY ')
3. Support + + operator
SET Stateid + 1
The complete example is as follows:
Copy Code code as follows:
CREATE TABLE statelist (stateid int, statename char (2))
Go
--Declare variable and assign a single statement
DECLARE @Id int = 5
--Insert multiple rows in a single statement with IDs 5, 6, and 7
INSERT into StateList VALUES (@Id, ' WA '), (@Id + 1, ' FL '), (@Id + 2, ' NY ')
--Use compound assignment operator to increment ID values to 6, 7, and 8
UPDATE StateList
SET Stateid + 1
--View The results
SELECT * from StateList
The result set is:
Stateid StateName
------- ---------
6 WA
7 FL
8 NY
(3 row (s) affected)
