/*
获取訂單編號
*/
alter function BSQZ_FN_GetSupplyComNo(@Title char(3))
returns Varchar(10)
as
Begin
return exec BSQZ_GetMaintainSeq @MaintainCate=@Title
End
获取訂單編號
*/
alter function BSQZ_FN_GetSupplyComNo(@Title char(3))
returns Varchar(10)
as
Begin
return exec BSQZ_GetMaintainSeq @MaintainCate=@Title
End
select @SupplyComNO= exec BSQZ_GetMaintainSeq 'AC'
select @SupplyComNO= exec BSQZ_GetMaintainSeq 'AC'
exec @SupplyComNO=BSQZ_GetMaintainSeq 'AC'-->output值
exec BSQZ_GetMaintainSeq 'AC',@SupplyComNO output
获取訂單編號
*/
Create function BSQZ_GetSupplyComNo(@Title char(3))
returns Varchar(10)
as
Begin
declare @rID nvarchar(10)
EXEC @rID =SupplySYS.dbo.BSQZ_GetMaintainSeq @Title
return @rIDEnd
这样写可行!