instead of insert.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 28 行

use test

create table books
(
    bookkey int identity(1,1),
    bookname nvarchar(10)not null,
    color nvarchar(10) not null,
    computedcol as (bookname+color),
    pages int 
)
go
 
create view view2
as
select bookkey,bookname,color,computedcol,pages
       from books
go

create trigger insteadtrig on view2
     instead of insert
as
begin
    insert into books
    select bookname,color,pages from inserted
end
go