1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE CURSOR People (PK I autoinc, FullName C(30), dob D NULL)
INSERT INTO People (FullName, dob) VALUES ("John Smith", {^1965-02-28})
INSERT INTO People (FullName, dob) VALUES ("Alex Black", {^1960-02-29})
INSERT INTO People (FullName, dob) VALUES ("Bill Doors", {^1968-02-27})
INSERT INTO People (FullName, dob) VALUES ("Sam Jobless", {^1958-03-01})
INSERT INTO People (FullName, dob) VALUES ("Nancy Davolio", {^1968-12-08})
INSERT INTO People (FullName, dob) VALUES ("Andrew Fuller", {^1952-02-19})
INSERT INTO People (FullName, dob) VALUES ("Janet Leverling", {^1963-08-30})
INSERT INTO People (FullName, dob) VALUES ("Margaret Peacock", {^1958-09-19})
INSERT INTO People (FullName, dob) VALUES ("Steven Buchanan", {^1955-03-04})
INSERT INTO People (FullName, dob) VALUES ("Michael Suyama", {^1963-07-02})
INSERT INTO People (FullName, dob) VALUES ("Robert King", {^1960-05-29})
INSERT INTO People (FullName, dob) VALUES ("Laura Callahan", {^1958-01-09})
INSERT INTO People (FullName, dob) VALUES ("Anne Dodsworth", {^1969-07-02})
INSERT INTO People (FullName, dob) VALUES ("Jack Lighthouse", NULL)
INSERT INTO People (FullName, dob) VALUES ("Cathy White", {})
|
Comments