开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜