Please give advice or comments-CodePudding

Neutron database query results for a value, you can use operator is what

CodePudding user response:

In
Not In

CodePudding user response:

The

reference 1/f, one tree forest _ response:

InNot In

Thank you, I also want to ask is there a clause to the query results in another table.

CodePudding user response:

refer to the second floor of my food I only arch response:

Quote: reference 1/f, one tree forest _ response:

InNot In

Thank you, I also want to ask is there a clause to the query results in another table.

Sql server using # Into the name of the table

CodePudding user response:

You can insert into a temporary table, or table variable,
In addition, you can also use common table expressions,
Similar:

; WITH cte AS (
SELECT * FROM TOP 10 [master] dbo. Spt_values AS sv 
) 
SELECT * FROM cte