--select * from tblDJCodeName
alter proc demo_codename_insert
@codetype varchar(20),
@name varchar(20),
@value int output
as
declare
@max int, @sort int
begin
select @max = max(value), @sort = MAX(Sort) from tblDJCodeName where Name = @name
if isnull(@max, '') <> ''
select @value = 1
else
[b]select @value = @max*2 [/b] --使用1,2,4,8.. 的设计风格
if @sort is null
select @sort = 1
else
select @sort = @sort + 1
insert tblDJCodeName(CodeType, Name, Value, Sort, IsDelete) values(@codetype, @name, @value, @sort, 0)
end
--执行
declare @val varchar(10)
exec demo_codename_insert 'com_demo', '测试', @val output
print @val
SQL Server 存储过程insert(自增value和sort)
最新推荐文章于 2022-03-27 21:13:26 发布