随笔分类 -  T-SQL

proc
摘要:use stuDBgoif exists(select * from sysobjects where name='bank') drop table bankcreate table bank( customerName char(10), currentMoney money)goalter table bank add constraint CK_currentMoney check(currentMoney>1)insert into bank(customerName,currentMoney) select '张三',1000 union se 阅读全文
posted @ 2012-04-26 09:43 杨伟明 阅读(149) 评论(0) 推荐(0)