SQL SERVER2 自定义函数及游标使用例子

定义：

Create   FUNCTION [dbo].[ufn_GetPLUBarCode] (@PLU varchar(30)) Returns varchar(1000)  AS
BEGIN
Declare @RetBarCodeList varchar(1000)
Declare @Item varchar(30)
Declare @LastItem varchar(30)
Declare RecCursor CURSOR FOR
Select Distinct BarCode From sales_tblItemBarCodeMaster Where PLU = @PLU
Order By BarCode
Set @LastItem  = ''
Set @RetBarCodeList = ''
Open RecCursor
 Fetch Next From RecCursor Into @Item
 Set @RetBarCodeList = RTrim(@Item)
 Set @LastItem = @Item
 WHILE @@FETCH_STATUS = 0
 BEGIN
  FETCH NEXT FROM RecCursor INTO @Item
   If @Item <>@LastItem
    BEGIN
     Set @RetBarCodeList = @RetBarCodeList + ',' + RTrim(@Item)
    END
   Set @LastItem = @Item
 END
Close RecCursor
Deallocate RecCursor
Return @RetBarCodeList
END

引用：1    Select dbo.[ufn_GetPLUBarCode] ('SA00035')

            2  select *, dbo.ufn_GetPLUBarCode(PLU) From tblItemmas