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?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

How can I change database in mysql?

0 Answers  

How to use rank function in mysql?

0 Answers  

What is difference between mysql and mysqli?

0 Answers  

What is the difference between unix timestamps and mysql timestamps?

0 Answers  




What is a blob datatype?

0 Answers  

How to get a list of all tables in a database?

0 Answers  

how to add a new column to an existing table?

0 Answers   MCN Solutions,

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

0 Answers  

What is a scalar function?

0 Answers  

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

0 Answers  

What is datadir?

0 Answers  

For more MySQL Interview Questions Click Here
Categories