Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE people (
- ident NCHAR(7) NOT NULL UNIQUE,
- first_name NVARCHAR(100) NOT NULL,
- last_name NVARCHAR(100) NOT NULL,
- notes NVARCHAR(4000) NULL,
- birth_year SMALLINT NULL,
- birth_location NVARCHAR(200) NULL,
- amount SMALLINT NULL,
- location NCHAR(6) NOT NULL,
- title_date INT NOT NULL,
- num INT NOT NULL UNIQUE,
- PRIMARY KEY (ident)
- );
- INSERT INTO people (ident, first_name, last_name, notes, birth_year, birth_location, amount, location, title_date, num)
- VALUES ('t1bbbee', 'Sam', 'Simpson', 'HKiONV6JGxKdd2qs5pQ3GGWlrSPRSfu19cJ6zyEn2qT1WHyv5N', 2007, 'N6fCeYVqJcjDov9DDmLfkpYtGs0WV4QeSVRaKm659lw52W21TX', 1143, 'YcbKbv', 19805274, 7735)
- SELECT p.ident + "-" + p.first_name + " " + p.last_name AS "name"
- FROM people AS p
- ORDER BY p.ident
- SELECT p.ident + '-' + p.first_name + ' ' + p.last_name name
- FROM people AS p
- ORDER BY p.ident
Add Comment
Please, Sign In to add comment