Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!