Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LEN('Hello') AS [0 trailing spaces],
- LEN('Hello ') AS [1 trailing spaces],
- LEN('Hello ') AS [2 trailing spaces],
- LEN('Hello ') AS [3 trailing spaces],
- LEN('Hello ') AS [4 trailing spaces],
- LEN('Hello ') AS [10 trailing spaces]
- ;
- SELECT CASE
- WHEN 'Hello' = 'Hello ' THEN 'EQUAL'
- ELSE 'NOT EQUAL'
- END
- ;
- SELECT 6.0/2.0*3.0,
- 6.0/-2.0*3.0
- ;
- SELECT CAST('' AS INT) AS [INT],
- CAST('' AS BIGINT) AS [BIGINT],
- CAST('' AS FLOAT) AS [FLOAT]
- ;
- SELECT CAST('' AS DECIMAL(15,6)) AS [DECIMAL],
- CAST('' AS NUMERIC(15,6)) AS [NUMERIC]
- ;
- SELECT *
- FROM EXAMPLE_TABLE
- WHERE COL1 = 5
- OR COL1 <> 5
- ;
- SELECT *
- FROM EXAMPLE_TABLE
- WHERE COL1 = 5
- OR NOT(COL1 = 5)
- ;
- SELECT *
- FROM EXAMPLE_TABLE
- WHERE COL1 NOT IN (1, 2, 3, 4, 5, NULL)
- ;
- SELECT *
- FROM EXAMPLE_TABLE
- WHERE 1 = 1
- ;
- SELECT *
- FROM EXAMPLE_TABLE
- WHERE NULL = NULL
- ;
- SELECT CAST(0.0000006 AS DECIMAL(38,22)) * CAST(1.000000 AS DECIMAL(38,22))
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement