select count_big(*) from Posts where datalength(Body) <= ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
    count_big(*)
from Posts
where
    datalength(Body) <= 8000
    and charindex(N'http://connect.microsoft.com', Body) > 0;

Enter Parameters

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