Untitled

mail@pastecode.io avatar
unknown
abap
3 years ago
495 B
0
Indexable
Never
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);