daily pastebin goal
18%
SHARE
TWEET

Untitled

a guest May 17th, 2018 95 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
Top