日期:2014-05-18 浏览次数:20823 次
if exists(select [Name] from tb1 where [Name]='张三') update tb1 set [Phone]='123' where [Name]='张三' else insert tb1 values('张三','123') end