CREATE PROCEDURE [sp_getdname]
@mid as int,
@name [varchar] (20) OUTPUT
As
SELECT @name = depart_name
FROM depart
WHERE depart_id = @mid

if @@rowcount < 1
SELECT @name = ''

GO

但在asp中如何调用呀！
name =getname(rec.field("id"),name)

function getname(id,name)
...
sql = "sp_getdname " & id & "," & name
...
end function