Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE PROCEDURE [dbo].[rbsUpdateSTAXINFO] @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 STAXINFO WHERE rtrim(CUSTOMER_NUMBER_STXI)=rtrim(@Old_CustomerID)) BEGIN SET @sql = ' update STAXINFO ' + ' set CUSTOMER_NUMBER_STXI = ' + @New_CustomerID + ' where CUSTOMER_NUMBER_STXI= @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
Join the community of 500,000 technology professionals and ask your questions.