How can I add my answer to the following question?

Hidden Features of SQL Server

The question is about the hidden features in SQL Server. Now I have a trick to give alias name to subquery columns. This trick is not present in existing answer

Here is the query.

        UNION ALL
        SELECT 1,NULL,'d',NULL
        UNION ALL
        SELECT 1,NULL,NULL,'c'
        UNION ALL
        SELECT 1,NULL,'d',NULL) a (groups, a, b, c)

How do I add this as an answer to the above mentioned question or can a moderator add this answer?

1 Answer 1


Did you read the post notice?

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed

This sort of question was once askable, and answerable on Stack Overflow - it no longer is (due to changing community standards), and as such new answers cannot be added.

Also, this question belonged on Stack Overflow meta as it is specific to that site, not to the network in general - which is what this meta is.

Not the answer you're looking for? Browse other questions tagged .