摘要: if exists(select * from sys.objects where name='bank')drop table bankCREATE TABLE bank( customerName nvarchar(10), --顾客姓名 [Money] MONEY --当前余额)ALTER TABLE bank --创建表 ADD CONSTRAINT CK_currentMoney CHECK([Money]>=1)INSERT INTO bank(customerName,[Money]) VALUES('张三',1000)INSERT INTO 阅读全文
posted @ 2011-08-28 13:22 _best 阅读(136) 评论(0) 推荐(0) 编辑