This project is read-only.

sp_join (Transact_SQL)

See also:


This user defined stored procedure is the opposite of SPLIT function converting a set of rows into delimited string.

Syntax

tsql.sp_join @sql,@delimiter,@string OUTPUT

Arguments

@sql = VARCHAR(8000) , string containing the table/view name or select statement to convert rows from;

@delimiter = CHAR(1), delimiter used for the list of values.

@string = VARCHAR(8000), OUTPUT list of values separated by @delimiter char

Return type

VARCHAR(8000)

Remarks

none

Permissions

Public

Dependencies

none

Examples

EXECUTE [Lib].[tsql].[sp_join] 'PRODUCTS', ',' , @RetVal OUTPUT

Result : 'Paint,Tools, Pipe'

Other

none


 

 

Last edited Sep 6, 2012 at 12:42 PM by adudau, version 1

Comments

No comments yet.