How to Truncate Tables in Microsoft Fabric?
In this post, I’ll show you how to truncate tables in Microsoft Fabric in three different ways: directly in the […]
database
How to Do Mathematical Operations in SQL?
When working with Microsoft SQL Server, you’ll quickly find that it’s not just about storing and retrieving data. You also
How to Import Excel into Fabric?
Recently, I had a situation where I needed to combine some data from an Excel file with the tables I
How to Use Date Functions in SQL
In this post, I’ll show you how to use date functions in SQL with practical examples. When working with Microsoft
How to Use String Functions in SQL?
When working with Microsoft SQL Server, you’ll often need to work with text, whether it’s combining names, cleaning up messy
Data Types in Microsoft SQL Server
When working with SQL Server, one of the first things you need to understand is data types in Microsoft SQL