Yahoo Poland Wyszukiwanie w Internecie

Search results

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

   stackoverflow.com › questions › 63447

   15 wrz 2008 · From this link, we can understand IF THEN ELSE in T-SQL: IF EXISTS(SELECT * FROM Northwind.dbo.Customers WHERE CustomerId = 'ALFKI') PRINT 'Need to update Customer Record ALFKI' ELSE PRINT 'Need to add Customer Record ALFKI' IF EXISTS(SELECT * FROM Northwind.dbo.Customers WHERE CustomerId = 'LARSE') PRINT 'Need to update Customer Record LARSE ...

2. 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 · In this article, we explored different options for executing IF-THEN logic in a SQL SELECT statement. These options include using CASE, IIF(), and CHOOSE(). Furthermore, if we want a query that’s used in almost every dialect, we must choose the CASE statement.

3. stackoverflow.com › questions › 13526592Using If else in SQL Select statement - Stack Overflow

   stackoverflow.com › questions › 13526592

   23 lis 2012 · Here are two ways "IF" Or "CASE". SELECT IF(COLUMN_NAME = "VALUE", "VALUE_1", "VALUE_2") AS COLUMN_NAME. FROM TABLE_NAME; OR. SELECT (CASE WHEN COLUMN_NAME = "VALUE" THEN 'VALUE_1' ELSE 'VALUE_2' END) AS COLUMN_NAME. FROM TABLE_NAME; edited Apr 6, 2020 at 11:46. Kennedy Maikuma.

4. 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

   The IF...ELSE statement is a control-flow statement that allows you to execute or skip a statement block based on a specified condition. The IF statement. The following illustrates the syntax of the IF statement: IF boolean_expression . BEGIN . { statement_block } END Code language: SQL (Structured Query Language) (sql)

5. 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 · Imposes conditions on the execution of a Transact-SQL statement. The Transact-SQL statement that follows an IF keyword and its condition is executed if the condition is satisfied: the Boolean expression returns TRUE. The optional ELSE keyword introduces another Transact-SQL statement that is executed when the IF condition isn't satisfied: the ...

6. www.golinuxcloud.com › sql-if-statement-in-selectHow the Hell I use SQL IF Statement in SELECT [5 Methods] -...

   www.golinuxcloud.com › sql-if-statement-in-select

   • Zapisane w pamięci cache

   30 paź 2023 · The SQL IF statement in SELECT queries is utilized to introduce conditional logic, allowing for more dynamic and flexible data retrieval. Essentially, it lets you specify conditions to dictate which data should be fetched or how it should be displayed.

7. www.golinuxcloud.com › sql-if-statement-tutorialSQL If Statement Tutorial [Practical Examples] - GoLinuxCloud

   www.golinuxcloud.com › sql-if-statement-tutorial

   • Zapisane w pamięci cache

   4 lis 2022 · In this Article of SQL If Statement, first we covered an overview and key point of SQL if statement, Syntax and syntax argument has been explained, Practical examples of SQL If Statement has been discussed with variable value in condition, constant value has been compared, SQL If with Select query to executed and at the end of the article ...