Testing concatenation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

Select 'Select ''' + ''' As [DatabaseName], Case WHEN TagName IS NULL Then ''' + 'Null' + ''' WHEN TagName = '''' Then ''Empty'' ELSE ''Unexpected'' End As [Type], Count(*) As [Count] from ' 
 + '[' + ']' + '..Tags Where IsNull(TagName,'''')='''' Group By TagName UNION'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results