Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-14 : 00:01:04
|
sardhi writes "i have written this trigger which fires to insert into msacess database but this doesnt work it gives an error no-7399
can u help me in identifying the bug
create trigger feedtblticker1 on tblticker for
insert,update as
DECLARE @Count int
SELECT @Count = COUNT(*) FROM Inserted
IF @Count > 0
BEGIN
INSERT INTO
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'd:\sar\DailytradingToCheck.mdb';'admin';'', tblticker )
SELECT i.*
FROM Inserted i
LEFT JOIN tblticker o2
ON i.companyid = o2.companyid
END" |
|
|
|
|
|
sqlserver 7 triggers