Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
BC160401693
---create database bc160400549 create table CUSTOMER( custID int primary key not null, Name nvarchar(50) not null, address nvarchar(50) not null, email nvarchar(50) not null ); create table CATEGORY( catID int primary key not null, catName nvarchar(50), intialRate float(50) ); create table SERVICES( serID int primary key not null, serTitle nvarchar(50) not null, serDescription nvarchar(max) not null, serCharges float(50) not null ); create table FOODITEM( itemID int primary key not null, itemName nvarchar(50) not null, description nvarchar(max) not null, ); create table MENU( menuId int primary key not null, noOfserving int not null, Quantity int not null, noOfItems int not null, ); create table VENUE( location nvarchar(250) not null, city nvarchar(250) not null, capacity nvarchar(250) not null, description nvarchar(250) not null ); create table EVENT( eId int primary key not null, Date date not null, timeSlot time not null ); insert into EVENT values(1,'7/12/2018', '08:34'); select * from EVENT;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
SQL Server Mistique!?
Manish_Sql_updated
FirstTable
Basic Template
NOT NULL field from SELECT INTO
string conversion
SS Sqlsvr2014 practice
InsertData.sql
Performance test - select vs while - Get all days between two dates.
SO 51804194 : sql-recursive-cte-replace-statement-too-slow
Please log in to post a comment.