UpdateLicenseTermAcceptedStatus.sql
629 Bytes
-- =============================================
-- Author: <Utkarsh Singh>
-- Create date: <07/21/2017>
-- Description: <Updates isTermAccepted field of License table >
-- =============================================
CREATE PROCEDURE UpdateLicenseTermAcceptedStatus
-- Add the parameters for the stored procedure here
@sAccountNumber char(16)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT OFF;
-- Insert statements for procedure here
UPDATE License SET IsTermsAccepted =1 WHERE AccountNumber = @sAccountNumber
END