Mercurial > pub > bltoolkit

annotate 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
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