Can 3 Sql Procedures Be In One ?

my asp code


Code:

Sub Hit(thetype,id)

RsForSub1.Open "HitUp2 "&thetype&","&id, database,1,3
if RsForSub1.eof then
RsForSub0.Open "HitUp3 "&thetype&","&id, database,1,3
end if

RsForSub1.close

RsForSub1.Open "HitUp "&thetype&","&id, database,1,3

RsForSub1.close

End Sub




HitUp2


Code:

CREATE PROCEDURE [dbo].[HitUp2]
@Type nvarchar(30),
@ID int
AS
Select * from Tbl WHERE gid=@ID and t=@Type
GO




HitUp3


Code:

CREATE PROCEDURE [dbo].[HitUp3]
@Type nvarchar(30),
@ID int
AS

INSERT INTO Tbl (gid, t)
VALUES (@ID, @Type)
GO



HitUp


Code:

CREATE PROCEDURE [dbo].[HitUp]
@Type nvarchar(30),
@ID int
AS
UPDATE Tbl SET Click=Click+1
WHERE gid=@ID and t=@Type
GO