Русский

English

03:04

			Content	Login

		SQL Problems and solutions S. I. Moiseenko

back go forward

Prepare for the second stage of testing

Transact-SQL string and datetime functions

String functions in MS SQL SERVER

Below is a full list of the string functions taken from BOL:


ASCII	NCHAR	SOUNDEX
CHAR	PATINDEX	SPACE
CHARINDEX	REPLACE	STR
DIFFERENCE	QUOTENAME	STUFF
LEFT	REPLICATE	SUBSTRING
LEN	REVERSE	UNICODE
LOWER	RIGHT	UPPER
LTRIM	RTRIM

Развернуть всё

Свернуть всё

Content:

(7.2.1.) ASCII and CHAR functions

(7.2.2.) LEFT function

(7.2.3.) CHARINDEX and PATINDEX functions

(7.2.4.) RIGHT function

(7.2.5.) LEN function

(7.2.6.) SUBSTRING function

(7.2.7.) REVERSE function

(7.2.8.) REPLACE function

(7.2.9.) REPLICATE and STUFF functions

(7.2.10.) STR, SPACE, LTRIM and RTRIM functions

(7.2.11.) LOWER, UPPER, SOUNDEX and DIFFERENCE functions

(7.2.12.) UNICODE and NCHAR functions

string functions PATINDEX CHARINDEX REPLACE LEFT SUBSTRING RIGHT LTRIM

Previos [DATENAME function]

[ASCII and CHAR functions] Next

Ремонт компьютеров, ноутбуков Мытищи, Королев

neongroup.ru

Last added:

donate

Tags

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

The book was updated
yesterday

©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.