use ZYTransport
go
Begin Transaction
Begin try
declare cursor_name cursor scroll for select name from sysobjects where xtype='u'
open cursor_name
declare @TableName nvarchar(20)
fetch next from cursor_name into @TableName
while @@FETCH_STATUS =0
begin
declare @Command nvarchar(1000)
set @Command=
'
create trigger Mytrigger_INSERT_'+@TableName+
' on '+@TableName+' for insert
as declare @CurrentTime datetime
select @CurrentTime=getDate()
begin
update '+@TableName+ ' set CreatedAt=@CurrentTime from '+ @TableName+', inserted
where '+@TableName+'.id=inserted.id
end
'
IF COL_LENGTH(@TableName, 'CreatedAt') IS NOT NULL
IF NOT EXISTS(select * from dbo.sysobjects where id = object_id(N'Mytrigger_INSERT_'+@TableName) and OBJECTPROPERTY(id, N'IsTrigger') = 1)
exec(@Command)
fetch next from cursor_name into @TableName
end
close cursor_name
deallocate cursor_name
commit Transaction
End Try
Begin Catch
rollback tran
End Catch
- 1
- 2
前往页