· 7 years ago · Dec 04, 2018, 09:36 AM
1if not exists (selecT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'Klasse')
2begin
3
4create table Klasse (
5 KlasseID varchar(300),
6 KlasseNavn varchar(300),
7)
8set identity_insert Klasse on;
9insert into Klasse(KlasseID, KlasseNavn)
10values
11 (1, 'A210'),
12 (2, 'E224'),
13 (3, 'D307');
14
15SELECT * FROM Klasse
16set identity_insert Klasse off;
17
18end