Access + MS SQL |
Create view dbo.[_] with view_Metadata as SELECT top 999999999999 ., ., ., ., ., ., ., ._, ., ., ., ., ., ., ., 1., 1., 1. FROM (( RIGHT JOIN ON . = .) LEFT JOIN ON . = .) LEFT JOIN (( LEFT JOIN ON . = .) LEFT JOIN 1 ON . = 1.) ON . = . WHERE (((.)>98) AND ((.)=8 Or (.)=12 Or (.)=13 Or (.)=19 Or (.)=18 Or (.)=20 Or (.)=21) AND ((.)=1)) OR (((.) Like '* *')) ORDER BY DESC
Create TRIGGER [dbo].[Update__] on [dbo].[_] INSTEAD OF Update AS BEGIN Update d set [] = i.[], [] = i.[], [] = i.[] From inserted i join dbo.[] d on d. = i. where i. in (select from ) insert into [] (, , , ) select , , , from inserted where inserted. not in (select from ) END; GO
http://www.sql.ru/forum/1296306/rabota-s-predstavleniem-v-access-ms-sql
