MariaDB: PIVOT
I googled “mariadb pivot” and the first answer was this. Ouch, this is a big (and complex) procedure. Then I scrolled down, but I couldn’t find a quick answer, so I created one. Here is the template: Keep it simple :-)
I googled “mariadb pivot” and the first answer was this. Ouch, this is a big (and complex) procedure. Then I scrolled down, but I couldn’t find a quick answer, so I created one. Here is the template: Keep it simple :-)
I create a web application and I need to show the navigation to the current page as breadcrumb. The structure of the menu is stored in the database and I will use a recursive CTE to show the current page as breadcrumb.
I met a code that CONVERT(BIT, Value) and insert into BIT column. Let’s see what are the possible values.
I needed to quote an identifier (a column name) with “<“. I checked the documentation for the build-in function QUOTENAME() and I did not find the information that I need. Here is a quick T-SQL to show which characters we can use as a second argument of the function.
SSISDB is the database that is collaborating with SSIS. When we execute a package, the execution information is logged in SSISDB. If a job is scheduled, we need to know if there are errors in the executions. As a last step in SSIS package, I run stored procedure that searches […]
In the last posts we played with Change Tracking (CT): T-SQL: Change Tracking – What is this and how it works T-SQL: Change Tracking Retention Period – How Long the Changes are Kept? Let’s execute few queries and see what do we have after the retention period expires.
In one of my web projects (ASP.NET and SQL Server) I have a screen with top 50 customers. To facilitate the client, I put few textboxes and give them the chance to filter the customers, until they reach the one that they need. In another case I use a textbox […]
As we mentioned in Change Tracking – What is this and how it works, the retention period is the one that determines how long the changes are kept.
Change tracking was introduced in SQL Server 2008. This is a tool that keeps the fact that there are changes in tracked tables for a specified period of time. It doesn’t show what the changes are, it tells that a data has been changed. It answers if a change has been […]
Hi Intuitive Learners, One year ago the Kindle version of Learn Microsoft® SQL Server® Intuitively. Transact-SQL: The Solid Basics was published on Amazon. Now the paperback version of the book is available on Amazon and you can take a quick look at it here. You can contact us all the […]