create procedure p_getNextID
    @processName  varchar(5)
as
begin
    print @processName+convert(char(8),getdate(),112)+right(cast(checksum(rand()) as varchar),5)
end

exec p_getNextID 'sm';
--结果
/*
sm2010042645794
*/

drop procedure p_getNextID;