Tag: SQL

SQL window functions are a powerful tool for performing calculations across a set of rows related to the current row. When combined with the PARTITION BY clause, these functions can provide deep insights into your data by breaking it into partitions, allowing you to perform calculations within each partition separately. In this post, we will

When working with SQL Server databases, you may often encounter scenarios where you need to extract specific parts of a string based on a pattern. A common requirement is to retrieve the substring that follows the last underscore (_) in a given string. This blog post will demonstrate how to achieve this using SQL Server

When working with SQL servers, it’s often useful to automate routine tasks using batch files. One common task is retrieving the server name where your database is running. In this post, we’ll walk through how to execute a SQL query from a batch file to get the server name using Microsoft SQL Server’s sqlcmd utility.

Specifies a temporary named result set, known as a common table expression (CTE). Microsoft Documentation Although there are some time around us the first time someone asked me about it I was confused: I haven’t know its proper definition until that momento. In fact, the common table expressions where added to the SQL standard in

I was looking how to know my server on the internet, and I’ve found this interesting question in Stackoverflow: How to get the connection String from a database. And one question give us an example of how do it using SQL: And it Works properly: