Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
zani
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CUSTOMER(custID, Name, address, email) CATEGORY(catID, catName, intialRate) SERVICES(serID, serTitle, serDescription, serCharges) FOOD-ITEM( itemID, itemName, description) MENU(menuId, no.Of.serving, Quantity, no.ofItems ) VENUE(location, city, capacity, description) EVENT(eId, Date, timeSlot )
run
|
edit
|
history
|
help
0
sqlserver
Demo
test44
Turn comma-separated numbers in string into rows
Xml Excercise 3
group for team members and winners in sql-server
Transaction Test
newtable
Transitive grouping with recursive sql
ESTEFANIA