Follow Madhivanan's SQL Blog on Feedspot

Continue with Google
Continue with Facebook

Madhivanan's SQL Blog
A blog to explore SQL.
While the formatting is generally done in a front end application, here is a T-SQL code to do it SQL Server create function dbo.[ ..read more
In the previous post Export to Excel – How to export data from SQL Server to EXCEL?, I have shown you how to export data from SQL Server ..read more
It is always good to explore SQL in different methods possible. One of them is to use it to print Greeting message. Today ARULMOUZHI, my ..read more
This code is not formatted and may not be understandable easily. However you will get a nice result set when you execute this All you ..read more
Feedspot, which ranks blogs of various technologies, has published a list of Top 50 SQL blogs for Microsoft SQL Server technology. I am ..read more
One of my friends asked me “Whenever I queried in SQL Server Management Studio, I keep on getting this error. How do I solve this?” An ..read more
Execute the following code SELECT DATENAME(WEEKDAY,10) AS DAY_NAME The result is DAY_NAME —————————— Thursday How does ..read more
ARULMOUZHI, My colleague and Blogger, has written a blog post on To Find Fill Rate in a Table on both AZURE and On-Premise – Key Metric ..read more
The most common requirement is to see data in EXCEL. In SQL Server it is possible to export data from table to EXCEL using various methods ..read more
Consider the following SELECT statement SELECT 1+'ONE' When executed, the above query throws the following error Msg 245, Level 16, ..read more

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview