正确写法:ALTER FUNCTION [dbo].[uf_GetContractPartyName] (
@ContractPartyID as uniqueidentifier
) RETURNS varchar(300)
AS
BEGIN
DECLARE @Ret varchar(300)
SELECT @Ret =PartyName
FROM tbl_biz_...
union
SELECT DISTINCT `JGH` FROM `金课50`UNION 会自动去重SELECT DISTINCT `JGH` FROM `水课50`;
SELECT DISTINCT `JGH` FROM `金课50`UNION ALL 不会自动去重SELECT DISTINCT `JGH` FROM `水课50`;
注释...