annotate Data/Queries/Person_SelectAll.sql @ 0:f990fcb411a9
Копия текущей версии из github
| author |
cin |
| date |
Thu, 27 Mar 2014 21:46:09 +0400 (2014-03-27) |
| parents |
|
| children |
|
| rev |
line source |
|
0
|
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
|
