annotate Data/Queries/Person_SelectAll.sql @ 5:f7d63a092920
Исправлено условие Where в тех случаях, когда репозитарий не является генериком
| author |
cin |
| date |
Tue, 10 Mar 2015 16:02:11 +0300 |
| parents |
f990fcb411a9 |
| 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
|
