Mercurial > pub > bltoolkit
comparison Data/Queries/Person_SelectAll.sql @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
-1:000000000000 | 0:f990fcb411a9 |
---|---|
1 IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Person_SelectAll') | |
2 BEGIN | |
3 DROP Procedure Person_SelectAll | |
4 END | |
5 | |
6 GO | |
7 | |
8 CREATE Procedure Person_SelectAll | |
9 AS | |
10 | |
11 SELECT * FROM Person | |
12 | |
13 GO | |
14 | |
15 GRANT EXEC ON Person_SelectAll TO PUBLIC | |
16 | |
17 GO | |
18 |