0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

EXEC dbo.sede_ineachdb N'

SELECT db = DB_NAME(), 
       p.Id, 
       p.Title,
       p.ViewCount, 
       p.Score, 
       p.CreationDate
  FROM Posts AS p 
 INNER JOIN Users AS u
    ON p.OwnerUserId = u.Id
 WHERE p.PostTypeId = 1 
   AND u.AccountId = ##AccountID:int##
 
';

fork query

edited apr 13

created apr 13 Aaron Bertrand