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: 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.
T-SQL: (Migration) Export the definition of Stored Procedures
Very often we need to bulk export database objects and move them to another server. Manually we do this by right click on the database –> Tasks –> Generate Scripts… In this example I show how we can export Stored Procedures with T-SQL and SQLCMD. This model gives us the […]
T-SQL: UDF Scalar Function to mask Credit Card numbers
We usually mask the credit card number in reports or end user data with asterisk (*). Here I show a scalar-valued function that masks the Credit Card Number.