在SQL中复制其他行项，循环遍历select查询以运行更新。

Question

因此，我需要复制表中已经存在的一些数据。例如，user表可以有一个用户，但该用户可能有20个不同帐户的20个条目。所以，当我有一个新用户需要复制一个不同的用户时，我正在做的是插入到table_a中(从table_a中选择UserID =‘UserID=’user to replicate)。现在，如果对每个条目运行一次，我如何让它遍历返回的多行，并为每个条目插入。

示例：

insert into DocSS (Username, Password, CustID, CURQ, CUPO, CUPL, CUCC, DYQT, DYRR, DYCT, DYWS, DYST, DYON, DYDT, DYQA, DYND, DYCO, DYCA, DYPO, DYIN, DYCH, DYAI, DYAP, DYCC, DYMS, OSCO, OSRM, OSCT, OSDT, OSIN, OSPL, UserAdmin, DYPL, DYVL, OSQT, RTEN, RTOT, RTDP, RTCF, RTFN, RTCS, RTQT, OnlineQuoteID, MonthlyRpt, RTER, OnlineQuoteID2, OnlineQuoteID3, ViewAllAccounts)
select 'the_new_userID', 'the_new_userID', CustID, CURQ, CUPO, CUPL, CUCC, DYQT, DYRR, DYCT, DYWS, DYST, DYON, DYDT, DYQA, DYND, DYCO, DYCA, DYPO, DYIN, DYCH, DYAI, DYAP, DYCC, DYMS, OSCO, OSRM, OSCT, OSDT, OSIN, OSPL, UserAdmin, DYPL, DYVL, OSQT, RTEN, RTOT, RTDP, RTCF, RTFN, RTCS, RTQT, OnlineQuoteID, MonthlyRpt, RTER, OnlineQuoteID2, OnlineQuoteID3, ViewAllAccounts
    from DocSS 
    where UserName = 'user_to_replicate' and CustID = '120180'

现在，不必再输入20个CustID并每次运行它，我如何执行相同的技术，但不使用CustID where子句，并为每个返回的行循环它？

Answer 1

您不想输入userId和客户名称，只需将其保留在where子句中，因为我已完全删除where子句。

insert into DocSS (Username, Password, CustID, CURQ, CUPO, CUPL, CUCC, DYQT, DYRR, DYCT, DYWS, DYST, DYON, DYDT, DYQA, DYND, DYCO, DYCA, DYPO, DYIN, DYCH, DYAI, DYAP, DYCC, DYMS, OSCO, OSRM, OSCT, OSDT, OSIN, OSPL, UserAdmin, DYPL, DYVL, OSQT, RTEN, RTOT, RTDP, RTCF, RTFN, RTCS, RTQT, OnlineQuoteID, MonthlyRpt, RTER, OnlineQuoteID2, OnlineQuoteID3, ViewAllAccounts)
select 'the_new_userID', 'the_new_userID', CustID, CURQ, CUPO, CUPL, CUCC, DYQT, DYRR, DYCT, DYWS, DYST, DYON, DYDT, DYQA, DYND, DYCO, DYCA, DYPO, DYIN, DYCH, DYAI, DYAP, DYCC, DYMS, OSCO, OSRM, OSCT, OSDT, OSIN, OSPL, UserAdmin, DYPL, DYVL, OSQT, RTEN, RTOT, RTDP, RTCF, RTFN, RTCS, RTQT, OnlineQuoteID, MonthlyRpt, RTER, OnlineQuoteID2, OnlineQuoteID3, ViewAllAccounts
    from DocSS ;