SQLQuery.sql 362 B

12345678910111213141516171819
  1. CREATE SCHEMA tests
  2. GO
  3. CREATE TABLE tests.FileProcessTest
  4. (
  5. FileName varchar(255) NULL,
  6. ExpectedValue [bit] NOT NULL,
  7. CausesException [bit] NOT NULL
  8. )
  9. GO
  10. INSERT INTO tests.FileProcessTest
  11. VALUES ('C:\Windows\Regedit.exe', 1, 0);
  12. INSERT INTO tests.FileProcessTest
  13. VALUES ('C:\BadFileName.txt', 0, 0);
  14. INSERT INTO tests.FileProcessTest
  15. VALUES (null, 0, 1);