3

Please login or register to vote for this query.

(click on this box to dismiss)

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
    Select CHARINDEX(@TextToFind, @RawLink);
End

view current version

edited oct 16 15

created oct 29 13 Shadow Wizard