Advertisement
Guest User

Untitled

a guest
May 17th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. GO
  2. CREATE PROCEDURE [elatesof_admin].[SelectPhotos]
  3. (
  4. @Id int = NULL,
  5. @PlaceId int =NULL,
  6. @IsMain bit = NULL
  7. )
  8. AS
  9. BEGIN
  10.  
  11. SELECT *
  12. FROM [PlacePhotos]
  13. WHERE (@Id is null or [Id] = @Id)
  14. and (@PlaceId is null or [PlaceId] = @PlaceId)
  15. and (@IsMain is null or [IsMain] = @IsMain)
  16.  
  17. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement