Hi Team,
I have written the below query to insert the records into table.
I have applied IS NULL condition if @IMSI param is not passing should be updated as NULL, rest all parm data should be inserted. Unfortunately the highlighted query itself is not working properly.
Can anyone suggest me regarding this
ALTER PROCEDURE [dbo].[sp_InsertIntoFavoriteAccount]
@AccountName varchar(200),
@AccountNumber varchar(200),
@BankName varchar(200),
@CustomerMSISDN varchar(20),
@OperationType varchar(10)='Add',
@IMSI varchar(500)=NULL,
AS
BEGIN
BEGIN TRY
IF(@IMSI IS NOT NULL)
BEGIN
INSERT INTO [dbo].[FavoriteAccountDetails] ([BANKNAME],[MSISDN],[IMSI],[ACCOUNTNUMBER],[ACCOUNTNAME], [OPERATIONTYPE],[LATESTUPDATEDDATE],[REQUESTEDDATE],[UPDATEDDATE])
VALUES(@BankName,@CustomerMSISDN,@IMSI,@AccountNumber,@AccountName,@OperationType,GETDATE(),GETDATE(),GETDATE())
SELECT 1 AS rowAffected;
END
ELSE IF((@IMSI IS NULL) or (@IMSI = ' '))
BEGIN
INSERT INTO [dbo].[FavoriteAccountDetails] ([BANKNAME],[MSISDN],[IMSI],[ACCOUNTNUMBER],[ACCOUNTNAME], [OPERATIONTYPE],[LATESTUPDATEDDATE],[REQUESTEDDATE],[UPDATEDDATE])
VALUES(@BankName,@CustomerMSISDN,@IMSI,@AccountNumber,@AccountName,@OperationType,GETDATE(),GETDATE(),GETDATE())
SELECT 1 AS rowAffected;
END
END TRY
END