-
Notifications
You must be signed in to change notification settings - Fork 0
/
Person.sql
40 lines (32 loc) · 1.05 KB
/
Person.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
use master
go
--int id;
--String name;
--boolean favorit;
--int hairColor;
--String address;
--String phone;
--String note;
create database PersonApiDB
go
use PersonApiDB
create table Person
(
id int identity (1000,1) primary key,
[name] nvarchar(25),
favorit bit,
hairColor int,
[address] nvarchar(35),
phone nvarchar(12),
note nvarchar(50)
)
go
insert into Person values('Jan', 0, 3, 'vej 5A', '003232327', 'Noget om mig')
insert into Person values('Ronald', 1, 5, 'vej', '0032325678', 'Noget om mig')
insert into Person values('Linette', 1, 2, 'vej7', '0232555', 'Noget om mig')
insert into Person values('Jannie', 1, 5, 'vej', '003333333', 'Noget om mig')
insert into Person values('Martin', 0, 1, 'vej 34', '002344324327', 'Noget om mig')
insert into Person values('Asger', 1, 1, 'vej 32', '0032423627', 'Noget om mig')
insert into Person values('Marc', 0, 4, 'vej 35', '0045233627', 'Noget om mig')
insert into Person values('Patrick', 0, 3, 'vej 109', '004532627', 'Noget om mig')
select * from Person