项目进行中的小问题-0418

create trigger trigger_name
　　on {table_name | view_name}
　　{for | After | Instead of } [ insert, update,delete ]
　　as
　　　　sql_statement

drop trigger trigger_name

alter trigger trigger_name
　　on {table_name | view_name}
　　{for | After | Instead of }
　　 [ insert, update,delete ]
　　as

use jxcSoftware go select * from sysobjects where xtype='TR'

　string sql=" select * from tableA where FieldA like '%' + @FieldA +'%' ";
　　string sql="exec('select * from tableA where FieldB in (' + @FieldB +')') ";