create trigger trig on tb
for insert
as
begin
insert tb2(nian,yue,ri) select datepart(year,date),datepart(month,date),datepart(day,date) from inserted
end
for insert
as
begin
insert tb2(nian,yue,ri) select datepart(year,date),datepart(month,date),datepart(day,date) from inserted
end
for insert
as
begin
insert tb2(nian,yue,ri) select cast(datepart(year,date) as text),cast(datepart(month,date) as text),cast(datepart(day,date) as text) from inserted
end
as
set nocount on
insert b(nian,yue,ri) select datepart(year,date),datepart(month,date),datepart(day,date) from inserted
set nocount off
go
as
set nocount on
insert b(nian,yue,ri) select datename(year,date),datename(month,date),datename(day,date) from inserted
set nocount off
go
?
用text类型干嘛----------------------空间太大了吧?
for insert
as
begin
insert t1(nian,yue,ri)
select datename(year,date),datename(month,date),datename(day,date) from inserted
end
Create Trigger Tri_Test On 表a
For Insert
As
Begin
Insert Into 表b(nian,yue,ri) Select
Rtrim(Year([date])),Rtrim(Month([date])),Rtrim(Day([date])) From Inserted
End
Go
wgzaaa() ( 一星(中级)) 信誉:100 2007-08-29 16:48:06 得分:0
?
用text类型干嘛----------------------空间太大了吧?
------------------------------------
哪里空间大啊?会占多大的空间啊?才占用几个字节啊?用Varchar觉得比较合理点
只不过我觉得没必要用Test类型,用Varchar难道就不能导入到Access吗??