Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.sqlservertutorial.net › sql-server-stored-procedures › sql-server-if-elseSQL Server IF ELSE Statement By Examples - SQL Server Tutorial

   www.sqlservertutorial.net › sql-server-stored-procedures › sql-server-if-else

   • Zapisane w pamięci cache

   Learn how to use the IF...ELSE statement to execute or skip a statement block based on a condition in SQL Server. See syntax, examples, and nested IF...ELSE statements.

   • SQL Server WHILE

     SQL Server WHILE - SQL Server IF ELSE Statement By Examples...

   • Cursor

     Cursor - SQL Server IF ELSE Statement By Examples - SQL...

   • Try Catch

     Try Catch - SQL Server IF ELSE Statement By Examples - SQL...

   • Dynamic SQL

     Dynamic SQL - SQL Server IF ELSE Statement By Examples - SQL...

2. learn.microsoft.com › en-us › sqlIF...ELSE (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   3 wrz 2024 · Learn how to use IF...ELSE to impose conditions on the execution of a Transact-SQL statement. See syntax, arguments, remarks, and examples for different scenarios and platforms.

3. stackoverflow.com › questions › 63447How do I perform an IF...THEN in an SQL SELECT?

   stackoverflow.com › questions › 63447

   15 wrz 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST ( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product. You only need to use the CAST operator if you want the result as a Boolean value.

4. www.w3schools.com › sql › sql_caseSQL CASE Expression - W3Schools

   www.w3schools.com › sql › sql_case

   • Zapisane w pamięci cache

   Learn how to use the SQL CASE expression to perform conditional logic like an if-then-else statement. See syntax, examples and a demo database.

5. simplesqltutorials.com › if-elseif-elseThe IF…ELSE IF….ELSE Statement: Everything You Should Know

   simplesqltutorials.com › if-elseif-else

   • Zapisane w pamięci cache

   24 maj 2021 · Learn how to use the IF…ELSE and IF…ELSE IF…ELSE decision structures in SQL to execute different blocks of code based on conditions. See examples of using these structures in stored procedures and tips for combining them with AND or OR operators.

6. learn.microsoft.com › en-us › sqlELSE (IF...ELSE) (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   21 maj 2024 · Learn how to use IF...ELSE to impose conditions on the execution of a Transact-SQL statement. See syntax, arguments, return types, and examples with queries and statement blocks.

7. www.baeldung.com › sql › select-conditional-logicHow to Execute an IF…THEN Logic in an SQL SELECT Statement -...

   www.baeldung.com › sql › select-conditional-logic

   • Zapisane w pamięci cache

   28 maj 2024 · Learn how to use different methods to implement IF-THEN logic in SQL SELECT statements across various databases. Compare CASE, IIF, CHOOSE, and IF functions with examples and syntax.