建一个函数:参数是社区编号
CREATE FUNCTION dbo.f_getNewHid (@Cid varchar(10))
RETURNS varchar(10)
AS
BEGIN
select @maxHid = max(hid) from Table
where hid like @Cid + '%'
return left(@maxHid,len(@cid)) + cast(cast(substring(@maxHid,len(cid) + 1,10) as int) + 1 as varchar(10))
建一个函数:参数是社区编号
CREATE FUNCTION dbo.f_getNewHid (@Cid varchar(10))
RETURNS varchar(10)
AS
BEGIN
select @maxHid = max(hid) from Table
where hid like @Cid + '%'
return left(@maxHid,len(@cid)) + cast(substring(@maxHid,len(cid) + 1,10) as int) + 1