Loading

Sql 字符串自增列的实现

ALTER FUNCTION [dbo].[f_NextID](@tabname VARCHAR(50)) RETURNS char(8) AS BEGIN DECLARE @charval CHAR(8) IF LOWER(@tabname) ='B_Fee_Type' SELECT @charval=RIGHT(100000001+ISNULL(MAX(id),0),8) FROM...
posted @ 2019-06-18 11:31  jevan  阅读(827)  评论(0编辑  收藏  举报