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
    DECLARE @document varchar(64);

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

view current version

edited oct 16 15

created oct 29 13 Shadow Wizard