Untitled
unknown
abap
4 years ago
495 B
8
Indexable
CREATE DATABASE CUS
create table Customer(
cusID int identity (1,1) primary key,
name varchar (50) not null,
Age int not null check (Age>=18),
Adress varchar (200) null,
salary decimal (18,2) null
)
Insert into Customer(name,Age,Adress,salary)
values ('Nahid', 21, 'Gulshan', 2000.00),
('Jahid', 22, 'Mirpur', 2000.00),
('Tonmoy', 21, 'Banani', 2000.00),
('Jui', 20, 'Footpath', 2000.00),
('Jannat', 24, 'Lalbagh', 2000.00),
('Rudra', 27, 'Dhanmondi', 2000.00);
Editor is loading...