· 4 years ago · Dec 15, 2020, 03:36 PM
1/*
2 * creation DB for lab
3 */
4
5use [master]
6drop database if exists [kr3];
7create database [kr3];
8use [kr3];
9
10
11create table [Animator] (
12 [ID] integer identity(1,1),
13
14 [Number] char not null,
15 [Fired] date null default('100622'),
16 [TestPole] int not null default(CRYPT_GEN_RANDOM(1))
17
18 primary key([ID])
19);
20
21insert into [Animator]([Number]) values('q'),('e'),('t'),('c');
22
23select * from [Animator]