Tag Archives: SQL Data types

Surrogate Key and Its Role in Data Warehouse or Data Mart

Surrogate key is term mostly used in data warehouse environments. We might not come by this term in application production databases simply because there is no need to generate these keys. We can do just fine with primary keys. It is much needed to create surrogate keys in data warehouses for many reasons, read further.… Read More »

SQL String Functions – Overview of Text Functions in T-SQL

T-SQL is not a language designed primarily to do something big with text strings or manipulate with them. That is the reason why we will not find many text-related built-in functions. But we will definitely find use for those that are there. Let’s take a look at SQL String Functions. 1) Text Concatenation (Combining) –… Read More »