Tag: SQL
All the articles with the tag "SQL".
-
Decrypting Encrypted Data with Subqueries in SQL
When working with encrypted data in SQL, it's essential to ensure that the decryption process is secure and efficient. One effective approach is using subqueries. In this post, we'll demonstrate how
-
Extracting the Last Part of a String in SQL Server
Introduction When working with SQL Server, you might often encounter scenarios where you need to extract a specific part of a string. For example, you might have a string in the format
-
Leveraging SQL Window Functions with PARTITION BY
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
-
Extracting Substrings from Strings in SQL Server
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
-
Running SQL Queries from a Batch File: Retrieving the Server Name
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
-
Common table expressions
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
-
Know your String Connection using SQL
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