Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  

---

Why does mysql have so many connections?

0 Answers  

---

How can we know the number of days between two given dates using MySQL?

2 Answers   Base2 Infotech, Webworks,

---

how many fields can be updated using set in a mysql query?

1 Answers  

---

can you elaborate on blob and text in mysql? : Mysql dba

0 Answers  

---

---

Is mysql open source?

0 Answers  

---

Is mariadb faster than mysql?

0 Answers  

---

What is row level locking?

0 Answers  

---

Where’s database data actually stored? Is there a way to see the files which are stored?

0 Answers  

---

How do I create a mysql username and password?

0 Answers  

---

How many rows can be inserted in mysql at a time?

0 Answers  

---

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  

---