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

0 Answers  

---

Is there a free mysql?

0 Answers  

---

Does mysql support sequence?

0 Answers  

---

What is the difference between primary key and candidate key?

0 Answers  

---

How can you take the backup and restore a mysql database using php?

0 Answers  

---

What is root password?

0 Answers  

---

If we use sum function in mysql, does it return sum of that row or for that column?

0 Answers  

---

How to use 'mysql' to run sql statements?

0 Answers  

---

Is mysqli faster than mysql?

0 Answers  

---

How can you import tables from a sql file into a database by using the mysql client?

0 Answers  

---

How can we get total number of records by query in mysql?

0 Answers  

---

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

3 Answers   ABC,

---