34,593
社区成员
发帖
与我相关
我的任务
分享
create FUNCTION [dbo].scd_dysh(@wlbh varchar(50),@ysmc varchar(50),@gg varchar(50))
RETURNS varchar(8000)
AS
BEGIN
DECLARE @str varchar(8000)
SET @str = ''
SELECT @str = @str + ',' + yssh+':'+zsl+dw ---类型转换
FROM wlck_sh where wlbh=@wlbh and gg=@gg and ysmc=@ysmc
RETURN STUFF(@str, 1, 1, '')
END
CREATE FUNCTION [dbo].scd_dysh
(
@wlbh VARCHAR(50) ,
@ysmc VARCHAR(50) ,
@gg VARCHAR(50)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @str VARCHAR(8000)
SET @str = ''
SELECT @str = @str + ',' + RTRIM(yssh) + ':' + RTRIM(zsl) + RTRIM(dw) ---类型转换
FROM wlck_sh
WHERE RTRIM(wlbh) = @wlbh
AND RTRIM(gg) = @gg
AND RTRIM(ysmc) = @ysmc
RETURN STUFF(@str, 1, 1, '')
END
最好确定一下是那个字段造成的这个问题……