20100720 Stored Procedure Introduction

CREATE PROC MyPROC01


AS

Select * from 供應商


Go

EXEC dbo.MyPROC01


Go

CREATE PROC MyPROC02


AS


SELECT 供應商編號,供應商,連絡人,地址,電話


FROM 供應商


WHERE 城市 LIKE '新竹%'


Go