执行带返回参数的存储过程:
create procedure
@Url nvarhcar(255),
@returnName nvarchar(50) output
as
select top 1 @returnName=[Name] from [Table_Name] where Url=@Url;
Delcare @returnName nvarchar(50)
exec proc_GetNamebyUrl @Url,@returnName output
print @returnName
转载于:https://www.cnblogs.com/Chailizi/archive/2007/12/13/993085.html