annotate Data/Queries/Person_SelectAll.sql @ 3:1ef98bd70424

!bug 100 +3h Исправление проблемы BLToolkit + mono 3.4
author cin
date Fri, 22 Aug 2014 17:34:46 +0400
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