T-SQL：SQL Server-数据库查询语句基本查询

select * from titles

select title_id,title,price,pub_id from titles

select * from title where title_id=9834

select * from title order by price

select * from authirs order by a_lname,a_fname

select type,count(title_id)as 每种类型数量 from title group by type

注意：where 在前 order by 其次 group by 最后

insert titles(,,,,) values(,,,,)

insert titles(title,price) values('thanks to java',23.5)

create proc ups_shj1
@title varchar(200),
@ytd_sales int output
as
select @ytd_sales=ytd_sales from titles where title=@title;

--执行存储过程，查找书籍'Sushi, Anyone?'
go
declare @sales int
exec ups_shj1 'Sushi, Anyone?',@ytd_sales=@sales output
select @sales