Transact SQL 101 - Lesson 07_02_SQL.txt

(0 KB) Pobierz

USE adventureworkslt
GO

--Example 1
--String Concatenation Operator 
SELECT firstname + ' ' + lastname AS 'Name', companyname 
FROM saleslt.customer

SELECT city + ', ' + stateprovince, countryregion
FROM saleslt.address
WHERE city = 'chicago'

--Example 2
--LEFT, RIGHT
SELECT productnumber, LEFT(productnumber, 2)
FROM saleslt.product

SELECT productnumber, RIGHT(productnumber, 2)
FROM saleslt.product

--Example 3
--SUBSTRING ( expression ,start , length )
SELECT SUBSTRING(Firstname, 1,1) + ' ' + LastName AS 'Customer Name'
FROM saleslt.customer

SELECT productnumber, SUBSTRING(productnumber,4,3) 
FROM saleslt.product

--Example 4
--CHARINDEX ( expression1 ,expression2 [ , start_location ] ) 
SELECT productnumber, CHARINDEX('-',productnumber)
FROM saleslt.product
 
SELECT productnumber, CHARINDEX('-',productnumber, 4)
FROM saleslt.product

SELECT productnumber, SUBSTRING(productnumber, charindex('-',productnumber) + 1, 4)
FROM saleslt.product

Plik z chomika:

morek3333

Transact SQL 101 - Lesson 07_02_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: