1.查询数据库里指定字段在哪个表里
select name
from sysobjects
where id in(select id from syscolumns where name='pl_pay_url')
2.触发器,在插入的时候,更改某项字段的值
CREATE TRIGGER tt ON [dbo].[p_emlmod]
FOR INSERT
AS
begin
declare @id int
declare @b nvarchar(50)
set @b='test ok'
set @id=(select ms_id from Inserted)
update p_emlmod set ms_bdy=@b where ms_id=@id
end