Mercurial > pub > bltoolkit

view Data/Queries/Person_SelectAll.sql @ 5:f7d63a092920

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Исправлено условие Where в тех случаях, когда репозитарий не является генериком
author cin
date Tue, 10 Mar 2015 16:02:11 +0300
parents f990fcb411a9
children
line wrap: on
line source

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Person_SelectAll')
BEGIN
	DROP  Procedure  Person_SelectAll
END

GO

CREATE Procedure Person_SelectAll
AS

SELECT * FROM Person

GO

GRANT EXEC ON Person_SelectAll TO PUBLIC

GO