开发者

How to write TSQL insert stored procedure with max value of previous serial numbers?

开发者 https://www.devze.com 2023-03-10 21:11 出处:网络
I have Letters table: +--------------+-------+ SerialNumber | Letter| +--------------+-------+ 1| A| 2开发者_StackOverflow| B|

I have Letters table:

+--------------+-------+
| SerialNumber | Letter|
+--------------+-------+
| 1            | A     |
| 2       开发者_StackOverflow     | B     |
| 3            | C     |
| 4            | D     |
+--------------+-------+

How to write TSQL insert stored procedure PA_Letters_INS which automatically adds max of previous serial number values and has letter insert parameter (without MSSQL autoincrement functionality on SerialNumber column).

(exec PA_Letters_INS 'E' adds {5, E} record)


@Letter being you Stored Procedure Parameter,

INSERT INTO Letters(SerialNumber, Letter)
     SELECT MAX(SerialNumber) + 1, @Letter 
     FROM Letters
0

精彩评论

暂无评论...
验证码 换一张
取 消