Tuesday, October 6, 2009

sql server



sql server string join
Today our dev team asked the question "Is there a way to join strings in sql server from a table output?" Immediately the DBA and I said yea concatenate. Well while that may be possible this might be an easier way. At first I though that using a select @var = @var + text would not concatenate across the table but it does. Ex. declare @blah table (text varchar(max)); insert into @blah values ('a'); insert into @blah values ('b'); insert into @blah values ('c'); insert into @blah values ('

Blog Content

No comments:

Post a Comment