执行带返回参数的存储过程:
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
posted on 2007-12-13 09:40  ◎寶☆呗  阅读(1583)  评论(0编辑  收藏  举报