Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

passing comma delimited string as parameter to stored proc Expand / Collapse
Posted Tuesday, March 4, 2014 7:11 AM



Group: General Forum Members
Last Login: Tuesday, December 6, 2016 8:08 PM
Points: 16,145, Visits: 16,850
bikrant.sharma (3/3/2014)
REPLACE(@DefaultValue, ',',''',''')
@DefaultValue = '''' + @DefaultValue + ''''

That doesn't help with a parameter. That is why you have to parse it. Read through the responses in this thread.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1547323
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse