qq_34059765的博客

数据从单用户模式恢复到多用户模式工作中急用记录一下declare @kid varchar(8000)set @kid=''select @kid=@kid+' kill '+cast(spid as varchar(8))from master..sysprocesseswhere dbid=db_id('数据库名')Exec(@kid)alter database 数据库名 set multi_user;...

insert into tableName select top 1 '刘婷婷1',18where not exists (select 1 from tableName where Age = 18 and Name = '刘婷婷1'); inset into 表名 select top 1 (你要插入的数据)not exists(select 1 from 表名 where ...