At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
WITH Photos AS ( SELECT ROW_NUMBER() OVER(Order by [CreatedDate] DESC) as RowNum ,[id] ,[CreatedDate] ,[ImageTitle] ,COUNT([id]) OVER () AS [totalRows] FROM [dbo].[Photos] where [UserId] = @Userid ) IF @@ROWCOUNT = 0 BEGIN PRINT 'No Photos' END ELSE PRINT 'Has photos'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.