Answer / lijo

SP's Stored procedures in simple words is a complied SQL
stt. where there is no need for compiling it again on
successive calls.

Trigger is mechanism to handle insert/update.., like
operation happening in database.

Index are used for searching where searching a indexed data
takes less time while comparing with un-indexed.

What are date and time intervals?

0 Answers  

---

How to control the max size of a heap table?

0 Answers  

---

How can you add and remove any column of a table?

0 Answers  

---

How to list or view all databases from the mysql server.

0 Answers  

---

How do you stop an access query?

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  

---

Are stored procedures precompiled?

0 Answers  

---

What is mysql server?

0 Answers  

---

What is regexp?

0 Answers  

---

Is mysql relational?

0 Answers  

---

What are numeric data types?

0 Answers  

---

What is mysqli_free_result?

0 Answers  

---