Veri tabani Lab 17.04.2018 (Salı)

By | 20.04.2018

Given us

1.Step Open SQL Server Management Studio

2.Step Create new Database (as name ‘personel’)

3.Step Create new Query

4.Step Create table “city”

5.Step Execute

6.Step Create table “personel”

7.Step Execute

8.Step USING “CROSS JOIN” Operator

9.Step Execute

10.Step USING “AVG”(Avarage/ortalama) Operator

11.Step Execute

12.Step USING “COUNT” Operator

or

13.Step Execute

14.Step USING “MAX, MIN” Operators

15.Step Execute

16.Step

17.Step Execute

18.Step USING “UPPER” Operator

19.Step Execute

20.Step USING “CHARINDEX” Operator

21.Step Execute

22.Step

23.Step Execute

24.Step USING “DATEPART” Operator

25.Step Execute

26.Step USING “DATEDIFF” Operator

27.Step Execute

Leave a Reply

Your email address will not be published. Required fields are marked *