How to show certain selected rows with the value "pcds".

0 Answers  

---

Which mysql function is used to concatenate string?

1 Answers  

---

What is cast in mysql?

0 Answers  

---

What are the 'mysql' command line arguments?

0 Answers  

---

What is datatype in mysql?

0 Answers  

---

Create table employee (eno int(2),ename varchar(10)) ?

0 Answers  

---

What is difference between mongodb and mysql?

0 Answers  

---

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,

2 Answers   HP,

---

What is mysql community edition?

0 Answers  

---

List some comparisons operators used in mysql?

0 Answers  

---

How can we store binary data in mysql?

2 Answers   HP,

---

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  

---