Transact SQL 101 - Lesson 02_SQL.txt

(0 KB) Pobierz

--Example 1
SELECT SalesOrderID + AccountNumber AS 'SaleNum'
FROM saleslt.salesorderheader

SELECT subtotal + taxamt AS 'Total' 
FROM saleslt.salesorderheader

--Example 2
SELECT modifieddate, customerid, companyname 
FROM saleslt.customer
WHERE modifieddate > 1-1-2007

SELECT modifieddate, customerid, companyname 
FROM saleslt.customer
WHERE modifieddate > '1-1-2007'

--Example 3
SELECT * 
FROM saleslt.customer 
WHERE companyname = 'A Bike Store'

SELECT * 
FROM saleslt.salesorderheader 
WHERE subtotal = 78.81

Transact SQL 101 - Lesson 02_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: