diff options
author | Gert Driesen <drieseng@users.sourceforge.net> | 2009-01-17 03:46:00 +0300 |
---|---|---|
committer | Gert Driesen <drieseng@users.sourceforge.net> | 2009-01-17 03:46:00 +0300 |
commit | 416d711c895894f26d92bc6b7bdc5d2a48a90f69 (patch) | |
tree | ec8679b27b14ce54b3dd54c18b895f3d62c5069a /mcs/class | |
parent | b49af57c79ee2f13c04728864db94b68b0471725 (diff) |
Added sp with mix of input and output parameters.
svn path=/trunk/mcs/; revision=123675
Diffstat (limited to 'mcs/class')
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql | 29 |
1 files changed, 24 insertions, 5 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql index b6dd129a234..8d327ecc4fa 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql +++ b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql @@ -213,13 +213,13 @@ grant execute on sp_get_age to monotester; -- =================================== END OBJECT EMPLOYEE ============================ --- SP : sp_326182 +-- SP : sp_326182a if exists (select name from sysobjects where - name = 'sp_326182' and type = 'P') - drop procedure sp_326182; + name = 'sp_326182a' and type = 'P') + drop procedure sp_326182a; go -CREATE procedure sp_326182 ( +CREATE procedure sp_326182a ( @param0 int out, @param1 int out, @param2 int out, @@ -234,4 +234,23 @@ begin end go -grant execute on sp_get_age to monotester; +grant execute on sp_326182a to monotester; + +-- SP: sp_326182b + +if exists (select name from sysobjects where + name = 'sp_326182b' and type = 'P') + drop procedure sp_326182b; +go + +CREATE procedure sp_326182b ( + @param0 int = 9, + @param1 decimal (5, 2) out) +as +begin + set @param1 = (@param0 + 2) + return 666 +end +go + +grant execute on sp_326182b to monotester;
\ No newline at end of file |