UFN_TRANSLATIONFUNCTION_MERCHANDISEPRODUCT
Return
Return Type |
---|
nvarchar(50) |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_TRANSLATIONFUNCTION_MERCHANDISEPRODUCT(@ID uniqueidentifier) returns nvarchar(50)
as
begin
declare @NAME nvarchar(50);
select @NAME = NAME from dbo.PRODUCT where ID = @ID;
return @NAME;
end