sql operator Archives - {coding}Sight https://codingsight.com/tag/sql-operator/ Blog for SQL Server DBAs and Developers Thu, 27 Oct 2022 11:44:38 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png sql operator Archives - {coding}Sight https://codingsight.com/tag/sql-operator/ 32 32 How to Use SQL SUM Function https://codingsight.com/how-to-use-sql-sum-function/ Fri, 27 Aug 2021 08:01:55 +0000 http://codingsight.com/?p=16411 SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used operators in SQL is SUM – a logical operation that produces the sum of all values in a column. This article will cover the basics of this operator usage in queries. Why Do You Need SQL …

The post How to Use SQL SUM Function appeared first on {coding}Sight.

]]> SQL UNION Cheat Sheet with 10 Easy and Useful Tips https://codingsight.com/sql-union-cheat-sheet-with-10-easy-and-useful-tips/ Fri, 22 Jan 2021 11:00:15 +0000 https://codingsight.com/?p=11477 Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been working before pops up a box with a red X icon. An “Operand type clash” error occurs pointing to a line with UNION. The “fire” starts. Sounds familiar? Whether …

The post SQL UNION Cheat Sheet with 10 Easy and Useful Tips appeared first on {coding}Sight.

]]> Using Alerts and Operators in SQL Server https://codingsight.com/using-alerts-and-operators-in-sql-server/ Sat, 04 Jan 2020 00:06:31 +0000 https://codingsight.com/?p=8324 Introduction With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still available. They are the key SQL Server Agent features that are related to anything in SQL Server automation.  Their roles are clear: Alerts, when configured, let database administrators know when a …

The post Using Alerts and Operators in SQL Server appeared first on {coding}Sight.

]]> T-SQL Regular Expression: LIKE Operator and Its Use-Cases https://codingsight.com/t-sql-regular-expression-like-operator-and-its-use-cases-2/ https://codingsight.com/t-sql-regular-expression-like-operator-and-its-use-cases-2/#comments Fri, 09 Aug 2019 00:45:44 +0000 https://codingsight.com/?p=7598 A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or text, which determines the search pattern. The following are some of the use cases for regular expressions: To identify the data using combinations, such as credit or debit card numbers, email …

The post T-SQL Regular Expression: LIKE Operator and Its Use-Cases appeared first on {coding}Sight.

]]> https://codingsight.com/t-sql-regular-expression-like-operator-and-its-use-cases-2/feed/ 1 T-SQL SET Operators Part 2: INTERSECT and EXCEPT https://codingsight.com/t-sql-set-operators-part-2-intersect-and-except/ Tue, 11 Jun 2019 00:58:26 +0000 https://codingsight.com/?p=7135 In my previous article, I explained the basics of set operators, their types, and prerequisites for their use. I also talked about UNION and UNION ALL operators, their usage and differences. In this article, we’re going to learn the following: EXCEPT and INTERSECT operators. Difference between INTERSECT and INNER JOIN. The detailed explanation of INTERSECT …

The post T-SQL SET Operators Part 2: INTERSECT and EXCEPT appeared first on {coding}Sight.

]]> Basic and Complex Uses of Not Equal Comparison Operator in T-SQL https://codingsight.com/basic-and-complex-uses-of-t-sql-not-equal-comparison-operator/ Mon, 06 May 2019 22:15:18 +0000 https://codingsight.com/?p=6905 This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic to slightly complicated SQL scripting tasks. The article also highlights the importance of understanding the correct use of Not Equal comparative operator with expressions. The Not Equal comparative operator is a very common operator used in T-SQL, however, …

The post Basic and Complex Uses of Not Equal Comparison Operator in T-SQL appeared first on {coding}Sight.

]]> T-SQL SET Operators Part 1: UNION and UNION ALL https://codingsight.com/t-sql-set-operators-part-1-union-and-union-all/ https://codingsight.com/t-sql-set-operators-part-1-union-and-union-all/#comments Sat, 04 May 2019 00:18:39 +0000 https://codingsight.com/?p=6895 In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it returns one result set. Following is the list of T-SQL SET operators: UNION UNION ALL INTERSECT EXCEPT To use SET operators, we must follow a number of rules: The result set of …

The post T-SQL SET Operators Part 1: UNION and UNION ALL appeared first on {coding}Sight.

]]> https://codingsight.com/t-sql-set-operators-part-1-union-and-union-all/feed/ 1 Advanced SQL: CROSS APPLY and OUTER APPLY https://codingsight.com/advanced-sql-cross-apply-and-outer-apply/ Thu, 14 Mar 2019 15:23:46 +0000 https://codingsight.com/?p=6460 In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY and OUTER APPLY along with examples of how they can be used. In particular, we will learn: the difference between CROSS APPLY and the JOIN clause how to join the output of SQL queries with table-evaluated functions how to identify …

The post Advanced SQL: CROSS APPLY and OUTER APPLY appeared first on {coding}Sight.

]]>