Recently, when I was at a conference, one of the attendees came to me to ask a question. The conversation was as below for cross-database transactions.
SQL SERVER – Split Comma Separated List Without Using a Function
The best way to learn something is to revisit some of the older blogs and then look at finding a more efficient way to work on the same problem. Recently I was looking at the forums to find a question come up again and again around making a comma separated list. This is not new over this blog and if you search you will get few. Long time ago I have written below blogs to show the values stored in table as comma separate list – this is not a rehash of what was written before but a newer way to solve the problem again.
SQL SERVER – Walking the Table Hierarchy in Microsoft SQL Server Database – Notes from the Field #076
[Note from Pinal]: This is a 76th episode of Notes from the Field series. Hierarchy is one of the most important concepts in SQL Server but there are not clear tutorial for it. I have often observed that this simple concept is often ignored or poorly handled due to lack of understanding. In…
Read MoreSQL SERVER – CONCAT function and NULL values
CONCAT is the new T-SQL function introduced in SQL Server 2012. It is used to concatenate the values. It accepts many parameter values seperated by comma. All parameter values are concatenated to a single string. A simple example is SELECT CONCAT('SQL Server',' 2012') which results to SQL Server 2012 The…
Read MoreSQL SERVER – Interesting Function AGENT_DATETIME
One in a while I come across such interesting side of SQL Server that it even surprises me. Just the other day I came across function AGENT_DATETIME. I had never used it before and now I just found usage example of the same. There can be several methods to convert…
Read More
SQL SERVER – Script to Convert Date to Julian Dates
There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01.
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
How many of us use some sort of date or datetime function when working with SQL Server? I cannot think of a single developer who would ever say they don’t work with datetime conversions in their application. Almost every application needs some manipulation of datetime datatypes. There are a number of pitfalls that can get into which we might not be aware. Here is a simple blog: Quiz with DATEADD Function that I would love to hear your views on what the output would be: