11:03
Content
Login
SQL Problems and solutions
S. I. Moiseenko
Content
SQL console
Tag >
string functions
Prepare for the second stage of testing
More tags:
SQL Server
,
SQL-92
,
date/time functions
Transact-SQL string and datetime functions
More tags:
SQL-92
,
Transact-SQL
,
date/time functions
String functions in MS SQL SERVER
More tags:
CHARINDEX
,
LEFT
,
LTRIM
,
PATINDEX
,
REPLACE
,
RIGHT
,
SUBSTRING
ASCII and CHAR functions
More tags:
ASCII
,
CHAR
LEFT function
More tags:
ASCII
,
CHAR
,
LEFT
CHARINDEX and PATINDEX functions
More tags:
CHARINDEX
,
PATINDEX
RIGHT function
More tags:
LEFT
,
RIGHT
LEN function
More tags:
CHARINDEX
,
DATALENGTH
,
LEFT
,
LEN
,
REPLICATE
SUBSTRING function
More tags:
LEN
,
SUBSTRING
REVERSE function
More tags:
CHARINDEX
,
REVERSE
,
RIGHT
REPLACE function
More tags:
DML exercises
,
LEN
,
REPLACE
REPLICATE and STUFF functions
More tags:
LEN
,
REPLICATE
,
STR
,
STUFF
STR, SPACE, LTRIM and RTRIM functions
More tags:
LTRIM
,
RTRIM
,
SPACE
,
STR
LOWER, UPPER, SOUNDEX and DIFFERENCE functions
More tags:
DIFFERENCE
,
LOWER
,
SOUNDEX
,
UPPER
UNICODE and NCHAR functions
More tags:
NCHAR
,
UNICODE
Last added:
HAVING clause
Numbering of rows in accordance with the order of values of a primary key
Exercise #(-2) page 4
Exercise #(-2) (tips and solutions) page 2
Exercise #(-2) page 2
Exercise #(-2) page 3
Exercise #(-2)
Appendix 2. Exercises list page 3
Appendix 2. Exercises list page 2
Appendix 2. Exercises list
Tags
tags search
aggregate functions
ALL
ASCII
AVG
Battles
Bezhaev
Bismarck
C.J.Date
Cartesian product
CASE
cast
CHAR
CHARINDEX
classes
COALESCE
common table expressions
comparison predicates
Computer firm
CONVERT
correlated subqueries
COUNT
CTE
data type conversion
database schema
DATEDIFF
DATEPART
DATETIME
DELETE
DISTINCT
EXCEPT
exercise (-2)
exercise 19
exercise 23
exercise 37
exercise 39
exercise 46
exercise 54
exercise 55
exercise 56
exercise 57
exercise 7
exercise 70
exercise 8
exercises
EXISTS
FROM
FULL JOIN
GROUP BY
grouping
Guadalcanal
More tags
HAVING
head ships
IDENTITY
IN
income
inner join
INSERT
INTERSECT
ISNULL
join operations
laptop
launched year
LEFT
LEFT OUTER JOIN
LEN
LTRIM
MAX
MIN
mistakes
MySQL
NOT IN
NULL
number sequences
number-sequence generation
numbering
ORDER BY
outcome
Outcomes
outer joins
OVER
paging
PARTITION BY
PATINDEX
PC
PIVOT
PostgreSQL
predicates
printer
product
Ranking functions
recursive CTE
REPLACE
RIGHT
ROW_NUMBER
ships
SQL Server
SQL-92
sql-ex.ru
string functions
subquery
SUBSTRING
tables join
tips and solutions
Torus
Transact-SQL
type conversion
UNION
UNION ALL
UNKNOWN
UPDATE
varchar
WHERE
window functions
WITH
упражнение 23
The book was updated
yesterday