What are the objects can be created using CREATE statement?

0 Answers  

---

Which mysql function is used to concatenate string?

1 Answers  

---

Why use stored procedures in mysql?

0 Answers  

---

Where is mysql data stored?

0 Answers  

---

What port is mysql running on?

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  

---

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

0 Answers  

---

What is the data source name for mysql?

0 Answers  

---

what if you really want to store the timestamp data, such as the publication date of the article?

2 Answers  

---

List the different types of normalization?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  

---

Explain timestamp?

0 Answers  

---