Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
bc150200055
--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
Fff
Add defination in column while create table
Unpivot Example
TUAN 7_QLCB
Test1
bc160401882
dynamic pivot
hdudh
Branch
base de datos dbfloreria