When using dynamic SQL there is always the possibility that someone will inject SQL that does harm. They can put queries that can drop objects or can create sysadmin logins. Running the scripts as low permission users can reduce the potential harm. But that takes time to research and is easy to cut. You can […]
Limiting permissions with “Execute as” when using dynamic SQL Read More »
I had an ETL project to copydata from one SQL Server to another. The conversion rules, the data constraints and other metadata were in an Excel spreadsheet. Many of the cells consisted of multiple rows of data. But how to extract the rows? I was able to shred these cells into SQL rows by using
Shredding multiline column using xml Read More »
“cross join” is a difficult to explain to trainees. The mechanics aren’t very complicated. However, the question is where you would ever use them? One example that I came up with is generating a calendar. Let’s say I want to generate a list of dates in a set of years. For example, I want a
SQL 2012 – Generate Calendar with Cross joins Read More »