cfstoredproc performance?
Hello,
In SQL2005, when i use<cfstoredproc></cfstoredproc>
from procedure..if i return result like this without using output parameter...Is there a performance problem?
create procedure tbl_a_list
as
@iD84_2_in as int;
select name, address, sal
from tbl_a
where id = @iD84_2_in
OR
If i use out parameter for all varibles?..Performance increase with CF?.
create procedure tbl_a_list
as
@iD84_2_in as int;
@8967549 varchar(25) output,
@address varchar(25) output,
@Sal8524867 int output,
select @8967549=name, @address=address,@sal=sal
from tbl_a
where id = @iD84_2_in
Please help me.
