summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql
diff options
context:
space:
mode:
authorwei <>2006-12-04 02:42:57 +0000
committerwei <>2006-12-04 02:42:57 +0000
commit562979c4a8fe47952edf7986d4144624e41630f7 (patch)
treeb79c3fd28e1aedb40d04e148da4b0763c928a3a5 /tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql
parent91fe694c8755aa2d05743946a3681be7232420b6 (diff)
add unit tests for active record and sqlmap
Diffstat (limited to 'tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql')
-rw-r--r--tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql b/tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql
new file mode 100644
index 00000000..d4b2199f
--- /dev/null
+++ b/tests/simple_unit/SqlMap/scripts/mssql/more-account-records.sql
@@ -0,0 +1,11 @@
+
+
+
+-- Creating Test Data
+
+INSERT INTO [dbo].[Accounts] VALUES(6,'Jane', 'Calamity', 'Jane.Calamity@somewhere.com', 'Oui', 200);
+INSERT INTO [dbo].[Accounts] VALUES(7,'Lucky', 'Luke', 'Lucky.Luke@somewhere.com', 'Oui', 200);
+INSERT INTO [dbo].[Accounts] VALUES(8,'Ming', 'Li Foo', null, 'Non', 100);
+INSERT INTO [dbo].[Accounts] VALUES(9,'O''Hara', 'Steve', 'Jack.OHara@somewhere.com', 'Oui', 200);
+INSERT INTO [dbo].[Accounts] VALUES(10,'Robert', 'O''Timmins', null, 'Non', 100);
+