请高手指导，高分相赠！

[zlz7803]

如何在表内容发生变化后，自动将表的内容导出到指定路径下并转化为文本格式。

[nboys]

用触发器:

create trigger t_name on tableName
for insert,update,delete
as
exec master..xp_cmdshell 'bcp DatabaseName..tableName out c:\a.txt -c -q -Usa -Ppwd'

[nboys]

用触发器:

可以加时间区分文件名:

create trigger t_name on [tableName]
for insert,update,delete
as
declare @time varchar(10)
set @time=convert(varchar,getdate(),112)
exec ('master..xp_cmdshell ''bcp [DatabaseName]..[tableName] out c:\backup'+@time+'.txt -c -q -Usa -Ppwd''')

[hjb111]

create trigger T_ChangTable on TableName
for insert,update,delete
as
exec master..xp_cmdshell 'bcp DatabaseName..tableName out c:\a.txt -c -q -U
"sa" -P "yourpassword"'

go