1 files changed, 90 insertions, 0 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/SCHEMA b/mcs/class/System.Data/Test/ProviderTests/sql/SCHEMA
new file mode 100644
index 00000000000..a23cff686f4
--- /dev/null
+++ b/mcs/class/System.Data/Test/ProviderTests/sql/SCHEMA
@@ -0,0 +1,90 @@
+DATABASE: monotest
+
+
+========================== TABLE : numeric_family ==================================
+TABLE:  numeric_family
+	id 		int 		PRIMARY KEY 		NOT NULL
+	type_bit 	bit 					NULL
+	type_tinyint 	tinyint 				NULL
+	type_smallint 	smallint 				NULL
+	type_int 	int 					NULL
+	type_bigint 	bigint 					NULL
+	type_decimal 	decimal (38, 0) 			NULL
+	type_numeric 	numeric (38, 0) 			NULL
+	type_money 	money 					NULL
+	type_smallmoney smallmoney 				NULL
+
+DATA:
+
+insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647);
+insert into numeric_family values (2,0,0,-32768,-2147483648,-9223372036854775808,-1000,-1000,-922337203685477.5808,-214748.3648);
+insert into numeric_family values (3,0,0,0,0,0,0,0,0,0);
+insert into numeric_family values (4,null,null,null,null,null,null,null,null,null);
+go
+
+========================== END TABLE : numeric_family ===============================
+
+
+========================== TABLE : binary_family ====================================
+TABLE:  binary_family
+
+	id 				int 		PRIMARY KEY 	NOT NULL
+	type_binary 			binary 				NULL
+	type_varbinary 			varbinary (255) 		NULL
+	type_blob 			image 				NULL
+	type_tinyblob 			image 				NULL
+	type_mediumblob 		image				NULL
+	type_longblob_image 		image				NULL
+
+
+
+insert into binary_family values (1, convert (image, '555555'), convert (image, '0123456789012345678901234567890123456789012345678901234567890123456789'), 
+					convert (image, '66666666'), convert (image, '777777'), 
+					convert (image, '888888'), convert (image, '999999'));
+--insert into binary_family values (2,
+--insert into binary_family values (3,
+insert into binary_family values (4,null,null,null,null,null,null);
+
+========================== END TABLE : binary_family ================================
+
+
+=================================== TABLE: EMPLOYEE ================================
+TABLE : employee
+
+	id 		int 		PRIMARY KEY 		NOT NULL
+	fname 		varchar (50) 				NOT NULL
+	lname 		varchar (50) 				NULL
+	dob 		datetime NOT 				NULL
+	doj 		datetime NOT 				NULL
+	email 		varchar (50) 				NULL
+
+
+insert into employee values (1, 'suresh', 'kumar', '1978-08-22', '2001-03-12', 'suresh@gmail.com');
+insert into employee values (2, 'ramesh', 'rajendran', '1977-02-15', '2005-02-11', 'ramesh@yahoo.com');
+insert into employee values (3, 'venkat', 'ramakrishnan', '1977-06-12', '2003-12-11', 'ramesh@yahoo.com');
+insert into employee values (4, 'ramu', 'dhasarath', '1977-02-15', '2005-02-11', 'ramesh@yahoo.com');
+
+=============================== END TABLE: EMPLOYEE ================================
+
+
+=============================== STORED PROCEDURE : sp_clean_employee_table =========
+SP : sp_clean_employee_table
+
+NAME: sp_clean_employee_table
+
+PROCESS:
+	delete from employee where id > 6000;
+
+============================ END STORED PROCEDURE : sp_clean_employee_table =========
+
+
+============================ STORED PROCEDURE : sp_get_age ==========================
+NAME: procedure sp_get_age
+PARAMETER :
+	NAME : fname TYPE: varchar (50) DIRECTION : in
+	NAME : age   TYPE: int 		DIRECTION : out
+PROCESS:
+	select age = datediff (day, dob, getdate ()) from employee where fname like fname;
+	return age;
+
+ =================================== END PROCEDURE : sp_get_age =====================
+\ No newline at end of file