Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
17 cards
()
Section 1

Preview this deck

IsNull Function

Front

1 / 17

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (17)

Section 1

(17 cards)

IsNull Function

Front

Checks whether a field has no value. SELECT LastName, FirstName, Address From Persons WHERE Address IS NULL ;

Back

Control of Flow Statements

Front

IF...ELSE WHILE BREAK CONTINIE BEGIN...END

Back

Concatenation

Front

Attaching two things side-by-side, frequently strings of text.

Back

NULLIF

Front

Returns null if the column or variable is value (). SELECT Name, NULLIF (Color, 'Multi') AS SingleColor FROM Sales.Products ;

Back

nchar

Front

Character data type with fixed length. Unicode. Often used with other languages.

Back

Alias

Front

SELECT Productid, Name, ListPrice, StandardCost AS cost, ListPrice - StandardCost AS Margin FROM Sales.Products ;

Back

JOIN

Front

2 tables

Back

Batches

Front

Back

COALESCE

Front

Returns the value of the first non-NULL column or variable in the list. SELECT Name, COALESCE (Discontinued,SellEndDate, SellStartDate) AS LastActivity FROM Sales.Products ;

Back

TRY_CAST

Front

Returns NULL if not possible. SELECT Name, TRY_CAST (Size AS Integer) AS NumericSize FROM Sales.Products ;

Back

NULL

Front

Missing value. Unknown.

Back

TRIGGER

Front

Auto run statement

Back

CAST

Front

Converts an expression from one data type to another data type. CAST (Prosuctid AS varchar(5)) + ':' + name AS ProductName FROM Sales.Products ;

Back

CASE

Front

SELECT Name, CASE WHEN SellEndDate ISNULL THEN 'On Sale' ELSE 'Discontinued' END AS SalesStatus FROM Sales.Products ;

Back

Transaction Control Statement

Front

BEGIN TRANSACTION COMMIT TRANSACTION ROLLBACK TRANSACTION

Back

Error Handling Statement

Front

TRY...CATCH

Back

CONVERT

Front

SELECT CONVERT (varchar(5), Productid) + ':' + Name + ProductName FROM Sales.Products ;

Back