Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

Please can the SQL code below be interpreted
IF @xMatchCriteria='MATCH12'
BEGIN
IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) )
BEGIN
SET @xTestMatchCriteria = @xMatchCriteria;
SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName,
@xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode
FROM #InsightData
where (EmailAddress=@xDCPEmailAddress )
END
ELSE
BEGIN
SET @xTestMatchCriteria='No'+@xMatchCriteria;
END
END

Question Posted / nurudeen

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is the purpose of using timestamp data type?

0 Answers  

What is mysql_pconnect?

0 Answers  

How do I run a query in mysql?

0 Answers  

What is mysql server?

0 Answers  

How do I create a new database in mysql?

0 Answers  

Explain the difference between procedure and function in mysql?

0 Answers  

How do I change the max connections in mysql?

0 Answers  

How to create table with same structure of student table in mysql?

0 Answers  

How many entries can mysql handle?

0 Answers  

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

0 Answers  

How do I start mysql in linux?

0 Answers  

What is difference between function and procedure in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories