What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
CREATE PROCEDURE [dbo].[rbsUpdateSTAXNOTE] @Old_CustomerID varchar(15), @New_CustomerID varchar(15), @Return_code int output AS declare @sql nvarchar(4000) SET @Return_Code = 1 /* If old customer ID is found, update it to the new customer ID */ IF EXISTS (SELECT * FROM STAXNOTE WHERE rtrim(CUSTOMER_NUMBER_STXN)=rtrim(@Old_CustomerID)) BEGIN SET @sql = ' update STAXNOTE ' + ' set CUSTOMER_NUMBER_STXN = ' + @New_CustomerID + ' where CUSTOMER_NUMBER_STXN= @Old_CustomerID' exec sp_executesql @sql, N'@Old_CustomerID varchar(15)',@Old_CustomerID END ELSE BEGIN SET @Return_Code=0 END SELECT @Return_Code RETURN GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.