F
Fucool
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE TRIGGER [FYKInsert] ON dbo.customer
FOR INSERT
AS
set nocount on
declare @valuea1 varchar(8)
declare @valuea2 varchar(50)
declare @valuea3 varchar(50)
declare @valuea4 varchar(50)
declare @valuea5 varchar(50)
declare @valuea6 varchar(50)
declare @valuea7 varchar(50)
declare @valuea8 varchar(50)
declare @valuea9 varchar(50)
declare cur cursor for select UserID, homepage, companyname, companyadd, telephone, faxphone, corporation, money, UserEmail from inserted
open cur
fetch next from cur into @valuea1,@valuea2,@valuea3,@valuea4,@valuea5,@valuea6,@valuea7,@valuea8,@valuea9
while @@FETCH_STATUS = 0
begin
insert into SqlText (SqlText) values(' if not exists (select UserID from customer where UserID= ''' + @valuea1+''' ) INSERT INTO customer (UserID, homepage, companyname, companyadd, telephone, faxphone, corporation, money, UserEmail) VALUES (''' + @valuea1+ ''',''' + @valuea2+ ''',''' +@valuea3+ ''',''' +@valuea4+ ''',''' +@valuea5+ ''',''' +@valuea6+ ''','''+@valuea7+ ''',''' +@valuea8+ ''',''' + @valuea9 +''')')
fetch next from cur into @valuea1,@valuea2,@valuea3,@valuea4,@valuea5,@valuea6,@valuea7,@valuea8,@valuea9
end
close cur
deallocate cur
set nocount off
我做了一個觸發器,如上, 用於記錄數據庫異動情況,但是有個怪現象,telephone, faxphone, corporation, money, UserEmail等這些字段隻有有一個沒有輸入,即為空時
出現了這個SQL語句沒有產生的情況,字段全部輸入則沒有問題,請教?????
FOR INSERT
AS
set nocount on
declare @valuea1 varchar(8)
declare @valuea2 varchar(50)
declare @valuea3 varchar(50)
declare @valuea4 varchar(50)
declare @valuea5 varchar(50)
declare @valuea6 varchar(50)
declare @valuea7 varchar(50)
declare @valuea8 varchar(50)
declare @valuea9 varchar(50)
declare cur cursor for select UserID, homepage, companyname, companyadd, telephone, faxphone, corporation, money, UserEmail from inserted
open cur
fetch next from cur into @valuea1,@valuea2,@valuea3,@valuea4,@valuea5,@valuea6,@valuea7,@valuea8,@valuea9
while @@FETCH_STATUS = 0
begin
insert into SqlText (SqlText) values(' if not exists (select UserID from customer where UserID= ''' + @valuea1+''' ) INSERT INTO customer (UserID, homepage, companyname, companyadd, telephone, faxphone, corporation, money, UserEmail) VALUES (''' + @valuea1+ ''',''' + @valuea2+ ''',''' +@valuea3+ ''',''' +@valuea4+ ''',''' +@valuea5+ ''',''' +@valuea6+ ''','''+@valuea7+ ''',''' +@valuea8+ ''',''' + @valuea9 +''')')
fetch next from cur into @valuea1,@valuea2,@valuea3,@valuea4,@valuea5,@valuea6,@valuea7,@valuea8,@valuea9
end
close cur
deallocate cur
set nocount off
我做了一個觸發器,如上, 用於記錄數據庫異動情況,但是有個怪現象,telephone, faxphone, corporation, money, UserEmail等這些字段隻有有一個沒有輸入,即為空時
出現了這個SQL語句沒有產生的情況,字段全部輸入則沒有問題,請教?????