摘要:
1. 增加 SET NOCOUNT ON 语句,较少不必要的还回数据件数: CREATE PROC dbo.ProcName AS SET NOCOUNT ON; --Procedure code here SELECT column1 FROM dbo.TblTable1 -- Reset SET 阅读全文
摘要:
BEGIN DECLARE @SAPHINMEICD VARCHAR(20); DECLARE @NEWHINMEICD VARCHAR(20); DECLARE @UPCOUNT INT ; DECLARE curSekDt CURSOR FOR SELECT [SAPHINMEICD] ,[NE 阅读全文