Mercurial > pub > bltoolkit

diff Data/Queries/Person_SelectAll.sql @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Data/Queries/Person_SelectAll.sql	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,18 @@
+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
+