" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Stored Procedure execution using MySQL Extension

Posted on November 24th, 2015 by SAMBIT MISHRA

Friends, here I am going to share an interesting thing which I faced recently. In PHP, everyone knows to establish a mysql connection we use (This is the standard) <?php mysql_connect(‘HOST_NAME’, ‘USER_NAME’, ‘PASSWORD’);\* Using MYSQL extnsion *\ /* OR */ mysqli_connect(‘HOST_NAME’, ‘USER_NAME’, ‘PASSWORD’);\* Using MYSQLi extnsion *\ ?> Presently, everyone is using Stored Procedures and […]

Temporary Tables or Table Variables: Choose One!

Posted on November 24th, 2015 by Mayukh Roy

Need a Dynamic Table inside Stored Procedure? We have two options:             a.Temporary Tables             b.Table Variable Which one is better to use? Which one can provide better performance? Lets have a look at both of them by the means of comparison: One: Transaction Logs are not recorded for Table Variables. This simply means, transaction or rollback […]