Blog: Madhivanan

210 blogs updated: 64 min. ago
SQL_VARIANT datatype and behaviour changes
When you use sql_variant datatype in sql server 2000, and add data to a table using union all, it will work though datatype of data differs ...
27-06-2018 05:26:37 Madhivanan SQL Server
Question of the month May 2018 – Find out erroneous query
In SQL Server, only one out of the following four SELECT queries will throw an error. What is it? Advertisements
31-05-2018 11:21:45 Madhivanan SQL Server
SQL Server – How to Uniquely identify a row?
Without seeing the table structure,If you are interested in knowing which columns uniquely identify a row in a table, you can use this syste...
30-04-2018 10:32:24 Madhivanan SQL Server
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

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