Blog: Madhivanan

210 blogs updated: 61 min. ago
Scripting out Stored Procedures and Functions using Query
One of my friends asked me if there is an way to script out the definitions of stored Procedures and Functions using Query. There can be sev...
30-03-2018 11:09:25 Madhivanan SQL Server
Question of the month February 2018 – Find query that gives different result
In SQL Server server, consider the following queries query 1 : select 12a4; query 2 : select 12e4; query 3 : select 12f4; query 4 : select 1...
28-02-2018 11:51:40 Madhivanan SQL Server
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

© 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.