Skip to content

Instantly share code, notes, and snippets.

@staypufd
Created August 27, 2014 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save staypufd/2194266106df07234fa6 to your computer and use it in GitHub Desktop.
Save staypufd/2194266106df07234fa6 to your computer and use it in GitHub Desktop.
create table quote (
id identity,
quotation varchar(1000) not null,
author varchar(100) not null,
);
insert into quote (quotation, author) values ('The hardest thing in the world to understand is the income tax.', 'Albert Einstein');
insert into quote (quotation, author) values ('The only thing that interferes with my learning is my education.', 'Albert Einstein');
insert into quote (quotation, author) values ('I am convinced that He (God) does not play dice.', 'Albert Einstein');
SELECT * FROM QUOTE WHERE ID = IDENTITY();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment