soundex.sql

来自「《VB6数据库开发指南》所有的例程的源码」· SQL 代码 · 共 29 行

if exists (select * from sysobjects 
    where id = object_id('dbo.SoundexText') and sysstat & 0xf = 3)
    drop table dbo.SoundexTest
GO

CREATE TABLE dbo.SoundexTest (
    LastName char (20) NULL ,
    FirstName char (20) NULL 
)
GO

INSERT INTO SoundexTest VALUES ('Brown', 'Laura')
INSERT INTO SoundexTest VALUES ('Browne', 'Laura')
INSERT INTO SoundexTest VALUES ('Brun', 'Laura')
INSERT INTO SoundexTest VALUES ('Braun', 'Laura')
INSERT INTO SoundexTest VALUES ('Broom', 'Laura')

INSERT INTO SoundexTest VALUES ('Harper', 'Bill')
INSERT INTO SoundexTest VALUES ('Harpster', 'Bill')
INSERT INTO SoundexTest VALUES ('Hahpah', 'Bill')
INSERT INTO SoundexTest VALUES ('Hopper', 'Bill')
INSERT INTO SoundexTest VALUES ('Hobber', 'Bill')
INSERT INTO SoundexTest VALUES ('Hooper', 'Bill')

INSERT INTO SoundexTest VALUES ('Kennedy', 'Dennis')
INSERT INTO SoundexTest VALUES ('Kenney', 'Dennis')
INSERT INTO SoundexTest VALUES ('Kennealy', 'Dennis')
INSERT INTO SoundexTest VALUES ('Kenney', 'Dennis')