... where solutions for script programming are found ...
Still remember the similar article I wrote regarding the title of this article? Well, if you want to implement breadcrumb using the SQL Server database, then here is the related Stored Procedures in SQL Server format. In other words, this following article will show you the same Stored Procedures in SQL Server instead of using [...]
There are so many articles in the Internet have explained us that the Nested Set Data Model has many advantages (although it is more complex among the others) for handling the Hierarchical Data Model. Some of the advantages of this Nested Set Data Model are: You can create unlimited levels and it only needs one [...]
Have you ever got difficulty when handling the duplicate records in a table in MySQL database, where you want to delete the records and pretty leaves one record from each duplicate records? This usually happens in the table who did not have the primary key, so that it can cause to store the duplicate records. [...]
Have you ever encountered the strange behavior while you were deleting the certain records from a table in MySQL database using an application you build, which those records cannot be deleted? Well, I have! Today, I encountered this problem. This is so weird, since I have never faced this situation before. Well, after doing some [...]
Wampserver is one of the popular PHP-Apache-MySQL server for Windows operating system. If you want to create your own web server, especially in your local computer, then you should use this software. It is a free software. After using this software for a few years, I have just realized that when we create a new [...]
Have you ever wanted to know which record has duplicate content based on the same content in a field in MySQL database? This information will be get after you select the records and display them which one have the same content by groupping them by that field. Well, here is the script how you can [...]
Today I faced an interesting situation while getting the certain characters from a field and wanted to display them by using SELECT DISTINCT statement in MySQL database. Suppose we had thousand records in a table and we wanted to get the certain characters from the first until the certain position counted 6 characters from the [...]
Recent Comments