新建 文本文档.txt

主要介绍了sql的基础教程

create database test
go
use test
go
create table buyers
(
	buyer_id int,
	buyer_name varchar(50)
)
go
insert into buyers values (1,'Adam Barr')
insert into buyers values (2,'Sean Chai')
insert into buyers values (3,'Eva Corets')
insert into buyers values (4,'Mary O’Melia')
go
create table sales
(
	buyer_id int,
	prod_id int,
	qty int
)
go
insert into sales values (1,2,15)
insert into sales values (1,3,5)
insert into sales values (4,1,37)
insert into sales values (3,5,11)
insert into sales values (4,2,1003)
go