SQL Server Hosting – HostForLIFE.eu :: How to Convert String To Table List in MS-SQL?

When we start programming in any language, mostly we use loop and we hit Server side code to list the data every time. This function is helpful in reducing our Server side code & increase Application performance.

We can send the list as a string, as it converts against as a list of rows.

SELECT Result FROM DBO.UF_StrToTable(‘1,2,3,4,5′,’,’)

Run the query given above in SQL Server and here is the output: