No empty TagNames in any existing database

Please login or register to vote for this query.

(click on this box to dismiss)
Q&A for Ubuntu users and developers
Select 'ServerFault' As [DatabaseName], Case WHEN TagName IS NULL Then 'Null' WHEN TagName = '' Then 'Empty' ELSE 'Unexpected' End As [Type], Count(*) As [Count] from [ServerFault.Exported]..Tags Where IsNull(TagName,'')='' Group By TagName UNION                                       

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Select 'SuperUser.Meta' As [DatabaseName], Case WHEN TagName IS NULL Then 'Null' WHEN TagName = '' Then 'Empty' ELSE 'Unexpected' End As [Type], Count(*) As [Count] from [SuperUser.Meta.Exported]..Tags Where IsNull(TagName,'')='' Group By TagName
edited apr 2 12
created apr 2 12
Mark Hurd
Enter Parameters

Options: Text-only results Include execution plan
Switch to meta site
Hold tight while we fetch your results
Results[:current/:total] Messages Graph Execution Plan
Download CSV Download XML
:records returned in :time ms:cached