SQL Trigger,indexes,Procedure

 (一)  更改数据库的恢复模式

Alter database [database_name] set recovery simple

 

(二) 查找表对应的Trigger是否存在

 

 if exists(select * from sys.objects where type='TR'  and upper([name])=upper('MoOperationVersion_AIU_LastUpdate')

disable/enable  trigger  dbo.MoOperationVersion_AIU_LastUpdate on dbo.table_name

------------------------------- after 用法

create trigger [T_insert] on [dbo].[test]
after insert/update/delete  not for replication
as
begin
   update [dbo].[test] set dbo.test.c='wei'
   from inserted a inner join dbo.test b
    on (a.i=b.i)
 
end

----------------------------------deleted 表,inserted表

 

(三)查找索引是否存在

 

 if exists(select * from sys.indexes where object_id=object_id('dbo.table_name')

and upper([name])=upper('Bundletagtime1')

alter  index bundletagtime1 on dbo.[table_name]  disable --关掉index

alter index bundletagtime1 on dbo.[table_name] rebuild --重新建立index

with ( PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON,

    ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = ON, ONLINE = OFF )

 

 

 

(四)执行批处理的语句

 declare @sql  nvarchar(4000)

execute sp_executesql @sql