如何在ASP中的单个查询中执行选择和插入 [英] How to execute select and insert in a single query in asp

问题描述

SELECT BookID, DATEDIFF(day, ReturnDate, getdate()) AS no_of_days
FROM LibraryBookIssueToStudent

INSERT INTO DueLibraryBooks (BookID, No_Of_Days) VALUES (404, -29)

如何将这两个查询合并为一个查询?

我想将这些值插入到运行Select命令后生成的DueLibraryBooks中.

在此先谢谢您.

How to merge this two query in a single one?

i want to insert those values into DueLibraryBooks which are generated after running the Select command.

Thanks in advance.

推荐答案

请尝试以下查询.

Try as below query.

INSERT INTO DueLibraryBooks (BookID, No_Of_Days)
SELECT BookID, DATEDIFF(day, ReturnDate, getdate()) AS No_Of_Days
FROM LibraryBookIssueToStudent;

编辑-要在Asp中执行SQL查询，请查看下面的链接.

http://www.w3schools.com/ado/met_conn_execute.asp

Edit - To execute SQL Query in Asp, have a look at below link.

http://www.w3schools.com/ado/met_conn_execute.asp

这篇关于如何在ASP中的单个查询中执行选择和插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！