《sqlserver2005分割字符串,循环输出示例》由会员分享,可在线阅读,更多相关《sqlserver2005分割字符串,循环输出示例(2页珍藏版)》请在金锄头文库上搜索。
1、function( 5)tempcreate varchar returns as begindeclare ch set source while ( source begin set insert set end return endf_splitstrtable ( tid( sourcevarcharas varchar ( 50) = source + split varchar ( 500 ), split( 50 )ch =left( temp sourcesource , charindex values ( ch) = stuff ( source , 1,( , , sou
2、rce , 1)- 1)charindex ( , , source1), )-select tid from dbo.f_splitstr(xxxxxxx,ttttt,yyyyyy,ererer,)-select getdate()declarei int , countNum int , para varchar ( 50) declare tid_cursor CURSOR for select tid from dbo . f_splitstr ( xxxxxxx,ttttt,yyyyyy,ererer , , ) open tid_cursorFETCH NEXT FROMtid_cursor into paraWHILE FETCH_STATUS = 0BEGINprint paraFETCH NEXT FROMtid_cursor into paraEND;CLOSE tid_cursor DEALLOCATE tid_cursorGO