sql server2000改变表结构和创建触发器的问题

[jjja]

有一表t1，现在想改变它的结构，给他加一列，如name，类型为char，请问如何用sql实现？

如果想给t1建一个触发器，当有insert发生时，把insert进的数据，写到另一个和t1相同结构的表t2中，这个触发器怎么写？

谢谢。

[CrazyFor]

alter table t1 add column name char(10)

----------
create ti....
as
insert into t2
select * from inserted

[wfy0089]

alter table 表名 add name char(列长)

[hjb111]

alter table t1 add column colname char(2) not null
go

create trigger t_insert on t1 for insert
as
select * into t2 from inserted
go

[hjb111]

select * into t2 from t1 where 1=2
create trigger t_insert on t1 for insert
as
insert table t2 select * from inserted
go

[wfy0089]

CREATE TRIGGER [TRIGGER NAME] ON [dbo].[表1]
FOR INSERT
AS
insert into 表2 select * from inserted

[jjja]

那如果时update和delete呢，相应的触发器是不是就上面的改一下就行了？

[happy_0325]

alter table t1 add column colname char(2)
go
create trigger t_insert on t1 for insert
as
insert into t2
select * from inserted

[happy_0325]

update:
create trigger t_insert on t1 for update
as
................
delete
create trigger t_insert on t1 for delete
as
delete from t2 where id in ( select id from deleted)
id 为主键

[happy_0325]

update:
create trigger t_update on t1 for update
as
delete from t2 where id in (select id from deleted)
insert into t2 select * from inserted

[jjja]

那如果table1属于db1下的user1，table2属于db2下的user2怎么办？
即db1.user1.table1和db2.user2.table2
且用user1建立Connection，对table1建update触发器，该怎么做呢？

[jjja]

如果表结构不同呢？
如table2中包含table1的所有字段，但是又比table1多几个字段？
insert触发器该怎么写？