create procedure   CPView
    @ID  int

as

select * from spzs where  ID=@ID
GO
