Answer / Dhirendra Kumar Trivedi

A SQL Statement is a plain text query that is executed against a database. In contrast, a PreparedStatement in MySQL is a precompiled SQL statement that can be reused multiple times with different parameters.

How you can create a trigger in mysql?

1 Answers  

---

Which statement is used to delete a table in MySQL.

1 Answers  

---

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1 Answers  

---

How large can a mysql table be?

1 Answers  

---

Where MyISAM table will be stored and also give their formats of storage?

1 Answers  

---

how we can find nth max salary from an employe table by using my sql?

8 Answers  

---

What does mysql_query return?

1 Answers  

---

What is maximum size of a database in MySQL?

13 Answers   Bastioncoup, CIS, NM, V2 Solutions, Wipro,

---

How can we repair a MySQL table?

2 Answers   Infosys,

---

how to add a new column to an existing table?

1 Answers   MCN Solutions,

---

what is collation? how many types of installations in sql server?

3 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

1 Answers  

---