Answer / Jyoti Sharma

A text delimiter in MySQL is a character that separates fields within a record and records within a file. Common examples include comma (,), semicolon (;), or pipe (|).

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

1 Answers  

---

What are the method you will follow while sql installing

1 Answers   Mind Tree,

---

How to return query output in xml format?

1 Answers  

---

How do I make an action query?

1 Answers  

---

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 Answers  

---

What is mysql ndb?

1 Answers  

---

what programming language which is used for testing and developement in sql?

3 Answers  

---

How to create a new table by selecting rows from another table in mysql?

1 Answers  

---

How do you use auto increment?

1 Answers  

---

What is the diff. bwt. primary key and unique key?

4 Answers  

---

How to make a copy values from one column to another in mysql?

1 Answers  

---

How can I change database in mysql?

1 Answers  

---