IF OBJECT_ID(N'GetMVenderList') IS NOT NULL DROP FUNCTION GetMVenderList GOCREATE FUNCTION GetMVenderList(@m_id NVARCHAR(100)) RETURNS NVARCHAR(1000) AS BEGIN DECLARE @STRSUPPLIERS NVARCHAR(1000) DECLARE CUR CURSOR FOR SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id OPEN CUR DECLARE @FS NVARCHAR(100) FETCH NEXT FROM CUR INTO @FS WHILE @@FETCH_STATUS = 0 BEGIN SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ',' FETCH NEXT FROM CUR INTO @FS END CLOSE CUR DEALLOCATE CUR RETURN @STRSUPPLIERS END GO
IF OBJECT_ID(N'GetMVenderList') IS NOT NULL DROP FUNCTION GetMVenderList GOCREATE FUNCTION GetMVenderList(@m_id INT) RETURNS NVARCHAR(1000) AS BEGIN DECLARE @STRSUPPLIERS NVARCHAR(1000) SET @STRSUPPLIERS = '' DECLARE CUR CURSOR FOR SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id OPEN CUR DECLARE @FS NVARCHAR(100) FETCH NEXT FROM CUR INTO @FS WHILE @@FETCH_STATUS = 0 BEGIN SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ',' FETCH NEXT FROM CUR INTO @FS END CLOSE CUR DEALLOCATE CUR IF @STRSUPPLIERS <> '' SET @STRSUPPLIERS = LEFT(@STRSUPPLIERS,LEN(@STRSUPPLIERS) - 1) RETURN @STRSUPPLIERS END GO
--参数该为int即可 IF OBJECT_ID(N'GetMVenderList') IS NOT NULL DROP FUNCTION GetMVenderList GOCREATE FUNCTION GetMVenderList(@m_id int) RETURNS NVARCHAR(1000) AS BEGIN DECLARE @STRSUPPLIERS NVARCHAR(1000) DECLARE CUR CURSOR FOR SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id OPEN CUR DECLARE @FS NVARCHAR(100) FETCH NEXT FROM CUR INTO @FS WHILE @@FETCH_STATUS = 0 BEGIN SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ',' FETCH NEXT FROM CUR INTO @FS END CLOSE CUR DEALLOCATE CUR RETURN @STRSUPPLIERS END GO
IF OBJECT_ID(N'GetMVenderList') IS NOT NULL
DROP FUNCTION GetMVenderList
GOCREATE FUNCTION GetMVenderList(@m_id NVARCHAR(100))
RETURNS NVARCHAR(1000)
AS
BEGIN
DECLARE @STRSUPPLIERS NVARCHAR(1000)
DECLARE CUR CURSOR FOR
SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id
OPEN CUR
DECLARE @FS NVARCHAR(100)
FETCH NEXT FROM CUR INTO @FS
WHILE @@FETCH_STATUS = 0
BEGIN
SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ','
FETCH NEXT FROM CUR INTO @FS
END
CLOSE CUR
DEALLOCATE CUR
RETURN @STRSUPPLIERS
END
GO
IF OBJECT_ID(N'GetMVenderList') IS NOT NULL
DROP FUNCTION GetMVenderList
GOCREATE FUNCTION GetMVenderList(@m_id INT)
RETURNS NVARCHAR(1000)
AS
BEGIN
DECLARE @STRSUPPLIERS NVARCHAR(1000)
SET @STRSUPPLIERS = ''
DECLARE CUR CURSOR FOR
SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id
OPEN CUR
DECLARE @FS NVARCHAR(100)
FETCH NEXT FROM CUR INTO @FS
WHILE @@FETCH_STATUS = 0
BEGIN
SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ','
FETCH NEXT FROM CUR INTO @FS
END
CLOSE CUR
DEALLOCATE CUR
IF @STRSUPPLIERS <> ''
SET @STRSUPPLIERS = LEFT(@STRSUPPLIERS,LEN(@STRSUPPLIERS) - 1)
RETURN @STRSUPPLIERS
END
GO
--参数该为int即可
IF OBJECT_ID(N'GetMVenderList') IS NOT NULL
DROP FUNCTION GetMVenderList
GOCREATE FUNCTION GetMVenderList(@m_id int)
RETURNS NVARCHAR(1000)
AS
BEGIN
DECLARE @STRSUPPLIERS NVARCHAR(1000)
DECLARE CUR CURSOR FOR
SELECT FSupplier FROM jxc_vender_material WHERE M_ID = @m_id
OPEN CUR
DECLARE @FS NVARCHAR(100)
FETCH NEXT FROM CUR INTO @FS
WHILE @@FETCH_STATUS = 0
BEGIN
SET @STRSUPPLIERS = @STRSUPPLIERS + @FS + ','
FETCH NEXT FROM CUR INTO @FS
END
CLOSE CUR
DEALLOCATE CUR
RETURN @STRSUPPLIERS
END
GO
SELECT DBO.GetMVenderList(35)