How can I create database in mysql?

0 Answers  

---

Explain the different types of constraints?

0 Answers  

---

How to calculate the difference between two time values?

0 Answers  

---

ru compare the 2 null values?

2 Answers   ACC,

---

What are date and time data types?

0 Answers  

---

Write a query to create a database and a table?

0 Answers  

---

What is a trigger in mysql?

0 Answers  

---

What is difference between mysql and mysqli?

0 Answers  

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  

---

Explain advantages of MyISAM over InnoDB?

1 Answers  

---

Can we save images in mysql database?

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  

---