Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GO
- CREATE PROCEDURE [elatesof_admin].[SelectPhotos]
- (
- @Id int = NULL,
- @PlaceId int =NULL,
- @IsMain bit = NULL
- )
- AS
- BEGIN
- SELECT *
- FROM [PlacePhotos]
- WHERE (@Id is null or [Id] = @Id)
- and (@PlaceId is null or [PlaceId] = @PlaceId)
- and (@IsMain is null or [IsMain] = @IsMain)
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement