Transact SQL 101 - Lesson 07_01_SQL.txt

(0 KB) Pobierz

USE adventureworkslt
GO

--Example 1
--SELECT 
SELECT GETDATE()

--PRINT
PRINT GETDATE()

--Function with Parameters
SELECT DAY('5/25/07')

--Example 2
SELECT LEN('String of Text')
SELECT UPPER('String of Text')

SELECT CustomerID, UPPER(CompanyName)  
FROM saleslt.customer

--Example 3
SELECT COUNT(*) FROM saleslt.Customer

SELECT SUM(totaldue) FROM saleslt.salesorderheader

SELECT AVG(totaldue) FROM saleslt.salesorderheader

Transact SQL 101 - Lesson 07_01_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: