alter function F_GetUserPostion(@userName varchar(120)) returns varchar(600)
as
begin
Declare curGetUserPostion Cursor
for
select (select column_Name from Hr_Professional where Column_id=Hr_Intention.GSsortID) from Hr_Intention where GuserName=@userName
Declare @ColumnName varchar(120)
Declare @body varchar(600)
--初始化
Set @body=''
set @ColumnName=''
--打開(kāi)游標(biāo)
Open curGetUserPostion
--循環(huán)并提取記錄
Fetch Next From curGetUserPostion Into @ColumnName
While ( @@Fetch_Status=0 )
begin
--更新到匯總表。
set @body = @body+'-'+@ColumnName
Fetch Next From curGetUserPostion Into @ColumnName
end
--關(guān)閉游標(biāo)
Close curGetUserPostion
--釋放游標(biāo)
Deallocate curGetUserPostion
return @body
end
文章來(lái)源:
http://www.cnblogs.com/wangdetian168/archive/2008/12/17/1356848.html
posted on 2010-10-11 09:27
sanmao 閱讀(140)
評(píng)論(0) 編輯 收藏