Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
bc160402152
create database bc160402152 create table CUSTOMER( custID int primary key not null, Name varchar(45) not null, address varchar(45) not null, email varchar(45) not null ); create table CATEGORY( catID int primary key not null, catName varchar(45), intialRate float(45) ); create table SERVICES( serID int primary key not null, serTitle varchar(45) not null, serDescription varchar(max) not null, serCharges float(45) not null ); create table FOODITEM( itemID int primary key not null, itemName varchar(45) not null, description varchar(max) not null, ); create table MENU( menuId int primary key not null, noOfserving int not null, Quantity int not null, noOfItems int not null, ); create table VENUE( location varchar(250) not null, city varchar(250) not null, capacity varchar(250) not null, description varchar(250) not null ); create table EVENT( eId int primary key not null, Date date not null, timeSlot time not null ); insert into EVENT values(1,'7/14/2018', '1:45'); select * from EVENT;
run
|
edit
|
history
|
help
0
gdfgfd
Window Functions - ROW_NUMBER()
service_delivery_task
MOVIE TIME
StackOverflow_53799678
Studiu Individual 1
exercise 1 – fines – database import 1.0.1.sql
NOT NULL field from SELECT INTO
sql-server-storing-wildcards-in-data
SQL SERVER 2012 how to split records in a column separated by delimiter