filmov
tv
What is Logical OR Operator in SQL Server - TSQL Tutorial Part 119
Показать описание
SQL Server / T-SQL Tutorial Scenario:
Logical Operators are used to test some conditions. If the condition is true, the row will be selected for output.
What is OR Logical Operator :
OR logical operator is used when we want to return the row if at least one of the condition is true.
Scenario :
Let's say that you have dbo.Customer table and you want to return all the rows if FName='Raza' Or CountryShortName='US'.
Link to scripts used in SQL Server / TSQL Tutorial Video
Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
Logical Operators are used to test some conditions. If the condition is true, the row will be selected for output.
What is OR Logical Operator :
OR logical operator is used when we want to return the row if at least one of the condition is true.
Scenario :
Let's say that you have dbo.Customer table and you want to return all the rows if FName='Raza' Or CountryShortName='US'.
Link to scripts used in SQL Server / TSQL Tutorial Video
Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)