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
Numbers
Delete cascade
CTE reqursive query
QLDT DB
Query to remove the string between two indexes of delimiters
REGISTRO_ESTUDIANTES
[SQLS]-Split and update a column
Xml Shredding
SQL Directives Order of Execution
mc170400712