Mercurial > pub > bltoolkit

annotate Data/Queries/Person_SelectAll.sql @ 8:a34cfdde80d6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
removed strong signing added FrameworkPathOverride for linux builds
author cin
date Wed, 29 Nov 2017 12:43:52 +0300
parents f990fcb411a9
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
1 IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Person_SelectAll')
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
2 BEGIN
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
3 DROP Procedure Person_SelectAll
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
4 END
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
5
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
6 GO
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
7
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
8 CREATE Procedure Person_SelectAll
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
9 AS
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
10
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
11 SELECT * FROM Person
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
12
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
13 GO
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
14
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
15 GRANT EXEC ON Person_SelectAll TO PUBLIC
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
16
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
17 GO
f990fcb411a9 Копия текущей версии из github
cin
parents:
diff changeset
18