declare @PrevDateTime datetime,
@NextDateTime datetime,
@Type varchar(20),
@sql varchar(8000)
select @sql='
INSERT INTO CNWinImportantProject(
ProjectID,
ProjectStartDate,
ProjectEndDate,
ConferTotalCost,
CNWinTotalCost,
Type,
BelongMonth
)
select projectid,'''+convert(char(19),@PrevDateTime,120)+''','''+convert(char(19),@NextDateTime,120)+''',0,0,'''+@Type+''',0
from SystemInitialize'
@NextDateTime datetime,
@Type varchar(20),
@sql varchar(8000)
select @sql='
INSERT INTO CNWinImportantProject(
ProjectID,
ProjectStartDate,
ProjectEndDate,
ConferTotalCost,
CNWinTotalCost,
Type,
BelongMonth
)
select projectid,'''+convert(char(19),@PrevDateTime,120)+''','''+convert(char(19),@NextDateTime,120)+''',0,0,'''+@Type+''',0
from SystemInitialize'
例如:
declare @PrevDateTime datetime,
@NextDateTime datetime,
@Type varchar(20),
@sql varchar(8000)
select @sql='
INSERT INTO CNWinImportantProject(
ProjectID,
ProjectStartDate,
ProjectEndDate,
ConferTotalCost,
CNWinTotalCost,
Type,
BelongMonth
)
select projectid,'''+convert(char(19),@PrevDateTime,120)+''','''+convert(char(19),@NextDateTime,120)+''',0,0,'''+@Type+''',0
from SystemInitialize'--此处执行事务
BEGIN TRAN.....................
EXEC(@SQL)
IF @@Error<>0
ROLLBACK TRAN
Else
COMMIT TRAN