In recent past, we got few problem when we need to do Pagination with SQL Server. I specially got frustrated when I saw that MySQL server has “limit” word that…
Category: SQL
MySQL “Server has gone away” error
A useful like to know the reason of “Server has gone away” error of MySQL. http://blog.taragana.com/index.php/archive/mysql-tip-mysql-server-has-gone-away-or-lost-connection-to-server-during-query-fix/ It has very good information on why it happens, so you can check and…
Comparing Date Range (Date Interaction checking through SQL)
As title says, I was looking to compare User give date range with date range saved in mysql Database. I search internet and found a great small function that solve…
Creating SQL Table from another table
Often we need to take quick backup of database with data before we can make changes in table. for this I create the image of table within same database, as…
Setting/Resetting Auto increment value in MSSQL 2005
Once you create a table and what to reset autoincrement value of a table to your desire number, you need to set some system table values, which are not available…