Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
gfhrey
CREATE DATABASE BC150402904 CREATE TABLE Coustomer( custID smallint constraint cID primary key, cNAME Varchar(25), cADDRESS Text, cEMAIL Text, ); SELECT*FROM Coustomer CREATE TABLE Category( catID smallint constraint catID primary key, catNAME Varchar(25), initalRate int, ); SELECT*FROM Category CREATE TABLE Services( serID smallint constraint serID primary key, serTitle Varchar(50), setDescription Varchar(50), serCharges int, ); SELECT*FROM Services CREATE TABLE Food_item( itemID smallint constraint itemID primary key, itemName Varchar(25), itemDescription Varchar(50), ); SELECT*FROM Food_item CREATE TABLE Menu( menuID smallint constraint menuID primary key, no.Of.serving int, Quantity int, no.Ofitems int, ); SELECT*FROM Menu CREATE TABLE Venue( location Varchar(50), city Varchar(50), capacity Varchar(50), description Varchar(50), ); SELECT*FROM Venue CREATE TABLE Event( eID smallint constraint eID primary key, Date datetime, timeSlot time, ); SELECT*FROM Event INSERT INTO Event VALUES('001','10.07.2018','12:00') SELECT*FROM Event
run
|
edit
|
history
|
help
0
SQL Server - NULL values with IN and NOT IN (Solution)
Pivot and Unpivot
IOU
SQL_Joins_RankingFunctions
get date part from datetime
Solution 4
28-02
SQL_Joins_RankingFunctions
Left join producing wrong result
Mc170404738