select id , 'http://meta.stackexchange.com/questions/'+ c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A about the Stack Exchange Network

select id
    , 'http://meta.stackexchange.com/questions/'+ cast(id as nvarchar) as [this is the url based on the primary key called id of the posts tabel used by SE]
    , body
    , owneruserid as [User Link]
    , id as [Post Link]
from posts 
where score > 100
and posttypeid = 1 --Q

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results