Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
552 views
in Technique[技术] by (71.8m points)

sql server - Filter on Output clause sql

I am trying to use a filter on an OUTPUT clause in t-sql.

What I want to do is something like this:

Insert into tbl_1(col1,col2)
Output Inserted.col1 into #tbl_temp 
**where col1 > 0**
select col3, col4
from tbl_2

For performance reasons I don't want to use two insert statements.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
insert into #tbl_temp
select col1
from
  (
    insert into tbl_1(col1,col2) 
    output Inserted.col1
    select col3, col4 
    from tbl_2
  ) as T
where T.col1 > 0

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...