CREATE TRIGGER tri1
ON car
FOR INSERT
AS
insert cardetail(carId,phone)
select carId,phone from inserted上面是我已经写好的触发器,
现在要添加这样的内容:
cardetial这种表同时要给属性jingdu,weidu,tras_time这三个属性设置默认值
(比如默认值jingdu=111.11,weidu=22.222,tras_time='2009-1-1 12:12:12.111')请问达人们这个怎么改啊?
ON car
FOR INSERT
AS
insert cardetail(carId,phone)
select carId,phone from inserted上面是我已经写好的触发器,
现在要添加这样的内容:
cardetial这种表同时要给属性jingdu,weidu,tras_time这三个属性设置默认值
(比如默认值jingdu=111.11,weidu=22.222,tras_time='2009-1-1 12:12:12.111')请问达人们这个怎么改啊?
修改默认值在触发器中不好,你直接对表更新默认值
alter tablename
alter 字段 类型 default '默认值'
ALTER TABLE TB ADD CONSTRAINT DF_TB_Col DEFAULT (0) FOR Col
ON car
FOR INSERT
AS
insert cardetail(carId,phone,jingdu,weidu,tras_time)
select carId,phone,111.11,22.222, '2009-1-1 12:12:12.111' from inserted
ON car
FOR INSERT
AS
BEGIN
insert cardetail(carId,phone,JINGDU,WEIDU,TRAS_TIME)
select carId,phone,111.11,22.222,'2009-1-1 12:12:12.111' from inserted
END这样就OK了。