Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
ALTER PROCEDURE [dbo].[SP_Update_Exchanges] @id int AS BEGIN Declare @currency int Declare @referencerate decimal(18,6) Declare @buy decimal(18,6) Declare @sell decimal(18,6) SET NOCOUNT ON; SELECT @currency=currency, @referencerate=referencerate, @buy=buy, @sell=sell from exchanges where systemdate = getDate()-1 BEGIN insert into exchanges (currency,referencerate,buy,sell,systemdate) values (@currency,@referencerate,@buy,@sell,getDate()) END END
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!