Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MC170402209
CREATE DATABASE MC170402209 CREATE TABLE Customer ( custID int primary key not null, custName varchar(255) not null, custAddress text not null, Email text not null, ); CREATE TABLE Catagory ( catID int primary key not null, custName varchar(255) not null, InitailRate int not null, ); CREATE TABLE S_ervices ( serID int primary key not null, serTitle varchar(255) not null, serDescription varchar(255) not null, serCharges int not null, ); CREATE TABLE Food_Item ( ItemID int primary key not null, ItemName varchar (255) not null, ItemDescription varchar(255) not null, ); CREATE TABLE Menu ( MenuID int primary key not null, no_of_servings int not null, quantity int not null, no_of_items int not null, ); CREATE TABLE Venue ( venueID int primary key not null, V_location varchar (255) not null, city varchar (255) not null, capacity int not null, V_description varchar (255) not null ); CREATE TABLE E_vent ( eID int primary key not null, eDATE date not null, TimeSlot time not null, ); insert into Venue ( venueID, V_location, city, capacity, V_description) values ( '002', 'multan', 'multan', '120', 'not available currently') select * from Venue;
run
|
edit
|
history
|
help
0
Display Multiple Rows as a single Line
product_sales
Sequence object -- New Feature of 2012 sql server
SS Sqlsvr2014 practice
SQL Server - NULL values with IN and NOT IN
code
Check Constraints
sql-server-storing-wildcards-in-data
Audit Example Simple
Test if a string can be made with substrings!