Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Agenda
Create table dbo.customers ( customerid int not null primary key, fname varchar(100) not null, emailid varchar(100) not null ) go create table dbo.orders ( orderid int not null primary key, customerid int null, ordereditem varchar(100) ) insert into dbo.customers values(101,'john','john123@gmail.com'), (102,'Rob','rob123@gmail.com'), (103,'david','david@gmail.com') insert into dbo.orders values(1001,101,'laptop'), (1002,102,'grocery'), (1003,null,'fruits')
run
|
edit
|
history
|
help
0
Seq
Jean
1D Hotel
Tabela Hospedes BD
SQL_leetcode
Cursor (procedural while)
TRANSACTIONS
ESTEFANIA
ms sql - update/insert - date concatenation
Task1