执行带返回参数的存储过程:
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
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