'Simple Storage Procedure 1. IF EXISTS (Select * from sysobjects where id = Object_id (' prgeteqid ') And ObjectProperty (ID,' IsProcedure ') = 1) Drop Procedure PrgeTeqidgo
Create Procedure Prgeteqid @chvmake varchar (50), @CHVMODEL VARCHAR (50) as select equipmentid from equipment where make = @ chavmake and model = @ chavmodel
'Output parameters
2.IF EXISTS (Select * from sysobjects
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
CREATE PROCEDURE prGetEqId @chvMake varchar (50), @chvModel varchar (50), @intEqId int outputAS SELECT @ intEqId = EquipmentId FROM Equipment WHERE Make = @ chvMake AND Model = @ chvModel
DecLare @inteqid intexecute prgteqid 'toshiba', 'PORTEGE 7020CT', @ INTEQID OUTSELECT @INTEQID 'Equipment Identifier'
'Return to integer collection
3.IF EXISTS (SELECT * from orig "
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
Create Procedure Prgeteqid @chvmake varchar (50), @chvmodel varchar (50) as declare @inteqid Int
SELECT @ inteqid = equipmentid from equipment where make = @ chavmake and model = @ chavmodelreturn @INTEQID
Declare @INTEQID INTEXECUTE @ INTEQID = Prgeteqid 'Toshiba', 'PORTEGE 7020CT' SELECT @INTEQID 'Equipment Identifier'
'Return to integer collection
4.IF EXISTS (SELECT * from Sysobjects
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
CREATE PROCEDURE prGetEqId @chvMake varchar (50), @chvModel varchar (50) AS RETURN (SELECT EquipmentId FROM Equipment WHERE Make = @ chvMake AND Model = @ chvModel) GODeclare @intEqId intExecute @ intEqId = prGetEqId 'TOSHIBA', 'PORTEGE 7020CT' SELECT @inteqid 'Equipment Identifier'
'Return to system parameters
5.if EXISTS (SELECT * from SysoBjects
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
CREATE PROCEDURE prGetEqId @chvMake varchar (50), @chvModel varchar (50), @intEqId int outputAS SELECT @intEqId = EquipmentId FROM Equipment WHERE Make = @ chvMake AND Model = @ chvModelRETURN @@ error GO
Declare @INTEQID INT, @INTERRORCODE INTEXECUTE @ InterRorcode = prgteqid 'Toshiba', 'PORTEGE 7020CT', @INTEQID OUTPUTSELECT @INTEQID RESULT, @INTERRORCODE ERRORCODE
'Default parameter value
6.if EXISTS (Select * from sysobjects
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
Create Procedure PrgeTeqid @chvmake varchar (50) = '%', @chvmodel varchar (50) = '%' as select * from equipment where make like @chvmake and model Like @chvmodelreturn @@ error Go
Declare @INTERRORCODE INTEXECUTE @ interrorcode = prgteqid 't%'
'Assignments to parameters according to the name
7..IF EXISTS (SELECT * from Sysobjects
WHERE ID = Object_ID ('prgteqid')
And ObjectProperty (id, 'isprocedure') = 1)
Drop Procedure PrgeTeqid
Go
CREATE PROCEDURE prGetEqId @chvMake varchar (50) = '%', @chvModel varchar (50) = '%' AS SELECT * FROM Equipment WHERE Make Like @chvMake AND Model Like @chvModelRETURN @@ error GODeclare @intErrorCode intExecute @ intErrorCode = prGetEqId @ chamodel = 'PORTEGE%' SELECT @INTERRORCODE ERRORCODE
