请问我这样写存储过程，如果执行不成功会回滚吗？
请问我这样写存储过程，如果执行不成功会回滚吗？如果不能回滚，该如何写这个SQL语句呢？请各位不吝赐教
CREATE   proc   p_insert_courtInformation
(
@ymd   char(10),
@field   char(4)
)
as
begin
tran
insert   into   field(ymd,   field)   values   (@ymd,   @field)
                insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0630,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0637,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0644,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0651,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0658,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0705,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0712,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0719,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0726,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0733,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0740,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0747,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0754,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0801,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0808,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0815,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0822,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0829,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0836,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0843,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0850,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0857,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0904,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0911,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0918,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0925,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0932,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0939,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0946,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,0953,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,1000,0)
insert   into   courtInformation(ymd,timepoint,bookcount)   values   (@ymd,1007,0)
insert   into