View a single comment based on ID or URL

3

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

DECLARE @TextToFind nvarchar(100) = '#comment';
DECLARE @CommentId int = ##CommentId?0##
DECLARE @RawLink nvarchar(512) = ##RawLink?null##
If @CommentId > 0 Begin
    Select PostId as [Post Link], Score, [Text], CreationDate, UserId As [User Link]
    From Comments
    Where Id=@CommentId
End Else Begin
    DECLARE @document varchar(64);

SELECT @document = 'Reflectors are vital safety' +
                   ' components of your bicycle.';
SELECT CHARINDEX('bicycle', @document);
End

Enter Parameters

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