|
|
От: | Alsin | |
| Дата: | 09.10.14 13:14 | ||
| Оценка: | |||
CREATE PROCEDURE dbo.pPersonGetIDByName
@Name nvarchar(50),
@ID int output
AS ...[ScalarSource(ScalarSourceType.OutputParameter)]
abstract int GetIDByName(string Name);id = pa.GetIDByName("testname");Procedure or function 'pPersonGetIDByName' expects parameter '@ID', which was not supplied.
declare @p2 int
set @p2=default
exec pPersonGetIDByName @Name=N'testname2',@ID=@p2 output
select @p2