Blog: Madhivanan


209 blogs updated: 16 min. ago
Use IN clause with care
IN clause can be used as a JOIN to get data by matching the column values from other table. Although this is much similar to INNER JOIN, be ...
3
16-08-2017 09:21:17 Madhivanan SQL Server
Avoid view creation with "SELECT *"
A view is very useful in giving out only the required/restricted information to the users. However see what happens when you create a view w...
3
09-08-2017 10:07:36 Madhivanan SQL Server
Question of the month July 2017 – Find out result of select 10.*10.[100]
What do you think the result of the following SELECT statement? select 10.*10.[100] Answers
6
26-07-2017 09:39:40 Madhivanan SQL Server
Dynamic sql execution – EXEC vs sp_executesql
The only way of executing dynamic sql is thru the usage of methods EXEC and sp_executesql. In this post we will explore the differences betw...
4
25-07-2017 11:54:45 Madhivanan SQL Server
Scripting out Data from a table
Everyone know how to script out a definition of a table. However many do not aware that you can script out data as well in the form of SELEC...
6
11-07-2017 09:13:26 Madhivanan SQL Server
Dynamic Crosstab with multiple PIVOT columns – Part 2
In Part 1 of this post, I showed a method of producing crosstab results using two PIVOT columns. In this post, I will show you the method of...
3
07-07-2017 08:48:58 Madhivanan SQL Server
Dynamic Crosstab with multiple PIVOT columns
Most of you know how to do crosstab result using a single PIVOT column. Here I explain how you can do the crosstab result with multiple PIVO...
3
06-07-2017 11:39:47 Madhivanan SQL Server
How to Get Column Names From a Specific Table?
Pinal Dave, blogger and speaker, posted about SQL Server How to Get Column Names From a Specific Table? where he showed two methods to get c...
3
03-07-2017 11:07:19 Madhivanan SQL Server
Question of the month June 2017 – Find out the result of select 100-+-+-+-100
Consider the following SELECT statement What do you think the result is?
0
28-06-2017 09:43:28 Madhivanan SQL Server
CASE Expression in WHERE Clause
Pinal Dave, Blogger and Speaker, posted about How to Write Case Statement in WHERE Clause? in which he showed a method to skip comparison of...
3
19-06-2017 09:18:20 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.