Transact SQL 101 - Lesson 07_03_SQL.txt

(0 KB) Pobierz

USE adventureworkslt
GO
--Example 1
--LEN
SELECT Len('Robert')

SELECT LEN(FirstName), FirstName FROM saleslt.customer

SELECT FirstName, LastName, CompanyName 
FROM saleslt.customer
WHERE LEN(FirstName) > 10

--Example 2
--LOWER/UPPER

SELECT UPPER('Some Text')

SELECT LOWER(City + ', ' + StateProvince), UPPER (CountryRegion) 
FROM saleslt.address

UPDATE saleslt.address SET stateprovince = UPPER('TX')
WHERE stateprovince = 'tx'

--Example 3
--LTRIM/RTRIM
DECLARE @First varchar(30), @Last varchar(30)
SET @First = 'First Name        '
SET @Last =  '  Last Name'
SELECT @First + '.' + @Last
SELECT RTRIM(@First) + '.' + LTRIM(@Last) AS 'Name'

--Example 4
--REPLACE
SELECT REPLACE('My Name is Robert','Robert','Pete') AS 'New Name'

Transact SQL 101 - Lesson 07_03_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: