T-SQL: Running Total or Replace Text with Running Variable in Groups
Running total in groups: Running text replace in groups: Get the result: Keep it simple :-)
T-SQL
T-SQL: Recursive CTE. List Child to Parent (Create Breadcrumb)
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.
T-SQL Hint: What are the values that we can insert into BIT column
I met a code that CONVERT(BIT, Value) and insert into BIT column. Let’s see what are the possible values.
T-SQL: The ‘quote_character’ in the Built-in Function QUOTENAME()
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.
T-SQL: Change Tracking Retention Period – What do we have after it expires
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.
T-SQL: How to Search for % in String (% and LIKE)
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 […]
T-SQL: Change Tracking Retention Period – How Long the Changes are Kept
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.
T-SQL: Change Tracking – What is this and how it works
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 […]
T-SQL: UDF Scalar Function to quote the DB Object Name
While working on ETL, I build a list of tables and their corresponding columns that need to be created on the destination server. In this case the square brackets around SchemaName and TableName are mandatory. I started adding the square brackets with the built-in function QUOTENAME(), but soon I got […]
T-SQL: UDF Scalar Function to Clean Multiple Spaces
While working on autocomplete dropdown, i created a simple scalar function that replaces multiple spaces with one.