摘要:
查询某个 逗号分隔的字段 select * from AccInformation a where '启用' in( select * from dbo.fnSplitStr(cCaption,',')) select * from dbo.fnSplitStr('1,2,3',',') CREAT 阅读全文
摘要:
CREATE PROCEDURE ProcedureNamme AS BEGIN SET NOCOUNT ON; BEGIN TRY 开始捕捉异常 BEGIN TRAN 开始事务 UPDATE A SET ... 9 ... INSERT INTO ...11 COMMIT TRAN 提交事务 EN 阅读全文