34,591
社区成员
发帖
与我相关
我的任务
分享
declare @a int
if (@a > 0)
set @a = 1
else if not (@a > 0)
set @a = 2
else
set @a = 3
declare @a int
if @a = null
set @a = 1
else if @a = null or 1 = 1
set @a = 2
else
set @a = 3
declare @i int
set @i = 1 / 0
set @i = 1
select @i
set xact_abort on
declare @i int
set @i = 1 / 0
set @i = 1
select @i
create table table1(id int primary key)
begin tran
insert into table1 values (1)
insert into table1 values (1)
insert into table1 values (2)
commit tran
set xact_abort on
create table table2(id int primary key)
begin tran
insert into table2 values (1)
insert into table2 values (1)
insert into table2 values (2)
commit tran
--已阅
select getdate()
/*
2009-08-12 14:02:42.233
*/