摘要:
alter PROCEDURE A01_Test @docno nvarchar(max)='', @CreatedOn nvarchar(max) AS BEGIN SET @docno= N'and '+ REPLACE(@docno, 'docno', 'docno'); if(ISNULL( 阅读全文
摘要:
If Not Exists(SELECT TOP 1 FullName From UBF_JOB_NoParaRunableBPSVList WHERE FullName='UFIDA.U9.Cust.Q.ZXBP.PublicBP.ProductIssueService') begin INSER 阅读全文
摘要:
1、定义sql函数 ALTER FUNCTION [dbo].[fn_GetItemStoreQty] ( @ItemID VARCHAR(50) --料品ID ) RETURNS decimal(24,9) AS BEGIN DECLARE @StoreQty decimal(24,9) SET 阅读全文