Framework-Database auto-generated numbering

automl framework

1.--Courseware auto-numbering
DECLARE @pt_OtherCateCode varchar (50)
exec app_s_spgetsequencenumber ' KJ ', 1, @pt_OtherCateCode output,0

2.
/*
Func: Get Auto number
createdate:20140829
Createuser:jesson
*/

Create Proc Sderp_spgetnumberexecute
(
@pi_Action varchar (50);

)
As
DECLARE @po_ProjectNumber varchar (50)
DECLARE @pt_maxval varchar (50)
if (@pi_Action = ' HZHB ')
Begin
Select @pt_maxval =max (partnercode,4) +1 from Sderp_partner
Set @po_ProjectNumber = ' HZHB ' + CONVERT (varchar (), GETDATE (), 112) +--Take seconds
(Select Case
When @pt_maxval are null then ' 0001 '--if the number is empty, a value is given first
else @pt_maxval
End
)

Select @po_ProjectNumber

End

automl framework

Framework-Database auto-generated numbering

best automl framework