EXECUTE [@return_value=]存储过程名 [[参数名(@Name)=]<value>,[参数名(@Name)=]<value>....]
其中: <value>中不能包含函数
例:
execute
procedureName
@id
=
newid
()
上面的语句不能执行,正确的如下:
declare
@newIdValue
uniqueidentifier
set @newIdValue = newId ()
execute procedureName @id = @newIdValue
注:参数[@Id]为GUID型(uniqueidentifier型)
set @newIdValue = newId ()
execute procedureName @id = @newIdValue