SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
?
--=================================================================
-- 描述：～～～～～～～～～～～～～～～～～～～～～～～～～～～
-- 作者：魯湘
-- @tableName?? 該模板對應(yīng)的數(shù)據(jù)庫表
-- @RecordID??? 業(yè)務(wù)處理需要尋找表中記錄的ID號碼
--=================================================================
ALTER??? PROCEDURE WF_QingJia
? ?(@tableName varchar(50),@recordID varchar(50))
AS
-- 獲取表中的業(yè)務(wù)數(shù)據(jù)值
DECLARE @money varchar(100),? -- 業(yè)務(wù)邏輯需要的值
?@sqls nvarchar(4000)? -- 保存組合SQL語句
SET @sqls='SELECT @a=Money FROM '+@tableName +' WHERE ID ='+@recordID
EXECUTE sp_executesql @sqls,N'@a varchar(50) output',@money output
-- 根據(jù)值進(jìn)行相應(yīng)的業(yè)務(wù)處理
print @money
UPDATE WF_FormBill SET [Money]='真的被處理了' WHERE [ID]=@recordID
?
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO