-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE TABLE names_and_notations (name_id INTEGER NOT NULL, name_type NVARCHAR2(20), PRIMARY KEY(name_id));
INSERT INTO names_and_notations VALUES(1,'PrimaryName');
INSERT INTO names_and_notations VALUES(2,'SecondaryName');
INSERT INTO names_and_notations VALUES(3,'PrimaryName');
SELECT COUNT(*) FROM names_and_notations WHERE name_type='PrimaryName';
SELECT COUNT(*) FROM names_and_notations WHERE name_type=N'PrimaryName';
DROP TABLE names_and_notations;
