Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33573 Views
- I also Faced
- E-Mail Answers
Answer Posted / riyas_isno
Triggers are used to identify changes (like insert,update
or delete) in database tables and captured in temp tables
seperately....it helps in business level logics...
procedures contains group of sql statements which are
precompiled ones.....
indexes helps in speedup our execution...
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what is the default port for mysql server? : Mysql dba
Why do we write stored procedures?
Where is mysql data stored?
what are the different tables present in mysql? : Mysql dba
Do I need to pay for mysql?
What is the use of count function in mysql?
What is mysql_connect?
How can you see all indexes defined for a table?
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
How to convert dates to character strings?
What is the default port number of mysql?
What are string data types?
What is mysql in dbms?
What is processlist in mysql?
What are the limitations of mysql?
