问题与sql查询有关 [英] problem is related to sql query

问题描述

我们可以通过SQL查询同时进行选择和插入吗?

can we do selection and insertion at the same time by SQL query

推荐答案

嗯，有点.

这取决于您要实际执行的操作.
您不能完全同时执行两项操作-但是您似乎可以使用命令链或存储过程.

这取决于您同时进行选择和插入"的实际含义.

Well, sort of.

It depends on what you are trying to actually do.
You can''t do two things at exactly the same time - but you can appear to using either command chaining, or a stored procedure.

It depends on what you actually mean by "do selection and insertion at the same time".

是的，请阅读以下内容:

Yes, read this : http://www.sqlteam.com/article/using-select-to-insert-records[^]

这篇关于问题与sql查询有关的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！