避免重复插入数据库
use [RYPlatformDB]
if not exists (select * from DataBaseInfo where DBInfoID = 1)
INSERT [DataBaseInfo] (DBAddr, DBPort, DBUser, DBPassword) VALUES ( '127.0.0.1' , 1433 , 'sa', 'fangyuan1793')
else
print '已经存在'
go
避免重复插入数据库
use [RYPlatformDB]
if not exists (select * from DataBaseInfo where DBInfoID = 1)
INSERT [DataBaseInfo] (DBAddr, DBPort, DBUser, DBPassword) VALUES ( '127.0.0.1' , 1433 , 'sa', 'fangyuan1793')
else
print '已经存在'
go