accounts.sql

来自「VB6数据库开发指南》的配套源程序」· SQL 代码 · 共 13 行

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)