create procedure login
@uid varchar(50)
as
begin
select * from person where uid=@uid
end
这是我在sql server中创建的存储过程,我想知道在程序中怎么调用?
參考答案:declare login procedure for login
@uid=:ls_id
using sqlca ;
execute login;
if sqlca.sqldbcode <> 0 then
rollback;
else
commit;
end if
close login;
