创建存储过程

1.1创建不带参数的存储过程

T-SQL语句如下：

USE Meitao

GO

IF EXISTS(SELECT*FROM sysobjects WHERE name ='proc_Product Info')

DROP PROCEDURE pro_Product_Info

GO 

CAEATE PROCEDURE pro_Proc_product_info

AS

SELECT title,categoryName,currentPrice,areaName,shopName

WHERE p.categoryID=c.categoryID AND p.areaID=a.areaID AND p.shopID=s.shopID

ORDER BY categoryName,currenPrice