Blog: Madhivanan

210 blogs updated: 40 min. ago
Question of the month January 2018 – What is the practical usage of table with only one identity column?
I wonder why it is possible to create a table with only one column that too with identity property. Have you ever used such a table? What is...
31-01-2018 18:23:52 Madhivanan SQL Server
Happy holidays from T-SQL
Curious to know the result of the following query? All you need to do is, in SQL Server, goto SSMS, set the result mode to Text (Press CTRL+...
29-12-2017 07:55:25 Madhivanan SQL Server
Question of the month December 2017 – How does ISNUMERIC work on characters d and e?
The following code The result is Note that the input has the characters d and e. The question is, In SQL Server, How does ISNUMERIC function...
27-12-2017 13:06:41 Madhivanan SQL Server
Question of the month November 2017 – How do leading dots of table work in SQL Server?
In SQL Server, let us consider the following data set Now execute the following query The result is 10 The question is "How do leading dots ...
29-11-2017 07:05:32 Madhivanan SQL Server
MySQL – Functions to get current date and time
You may often need to do some data filters based on the current date and time. In MySQL you can use the system functions available to get cu...
20-11-2017 10:19:16 Madhivanan SQL Server
MySQL – How to create random number with fixed length?
One of my friends asked me "How do I create a 10 digit random number?" MySQL supports RAND() system function which can produce a random numb...
06-11-2017 11:58:40 Madhivanan SQL Server
Question of the month October 2017 – What is the use of underscores in comparison?
In MySQL, Let us consider the following example SELECT * FOM table WHERE col like _____' What is the use of underscores here? How does it wo...
26-10-2017 05:13:43 Madhivanan SQL Server
MySQL – Simple ways to know version number with @@version and version()
If you want to know the version number of MySQL server, there are two simple methods available. You can use system variable @@VERSION as sho...
20-10-2017 08:14:48 Madhivanan SQL Server
MySQL – Concatenate column values for each group with GROUP_CONCAT function
As I said in my earlier posts, MySQL has some interesting features that make the things simpler. GROUP_CONCAT is one of such functions This ...
16-10-2017 08:02:36 Madhivanan SQL Server
MySQL – UPSERT in a single statement
MySQL, an opensource RDBMS, has lot of interesting features. One of them is ON DUPLICATE KEY UPDATE statement. This statement adds a new row...
10-10-2017 12:07:07 Madhivanan SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.