accounts.sql

VB6数据库开发指南》的配套源程序

CREATE TABLE dbo.Accounts (
	AccountId int NOT NULL ,
	Name varchar (255) NOT NULL ,
	Balance money NOT NULL 
)
GO
INSERT Accounts (AccountId, Name, Balance) VALUES (1, "Joe", 124.34)
INSERT Accounts (AccountId, Name, Balance) VALUES (2, "Jane", 100.00)
INSERT Accounts (AccountId, Name, Balance) VALUES (3, "Janet", 78.22)
INSERT Accounts (AccountId, Name, Balance) VALUES (4, "Jeff", 24.87)
INSERT Accounts (AccountId, Name, Balance) VALUES (5, "Jack", 56.32)
INSERT Accounts (AccountId, Name, Balance) VALUES (6, "Jill", 34.98)