create procedure.sql

来自「Delphi7数据库开发教程,包含该书21套实例」· SQL 代码 · 共 9 行

create procedure up_books_info
as
  select title, type, price, pub_name
  from titles 
    inner join publishers
    on titles .pub_id = publishers.pub_id
  where pub_name like 'B%' and price > 2