如何从记录集值创建表

Question

如何从记录集值创建表

sqlCardEvent1 = "select * from tmp_CARDEVENT"
    If rsCardEvent1.State = 1 Then rsCardEvent1.Close
    rsCardEvent1.Open sqlCardEvent1, Cn, adOpenStatic, adLockOptimistic
    cmdCardEvent1.CommandText = sqlCardEvent1
    Set rsCardEvent1 = cmdCardEvent1.Execute

    sql33 = "create table tmp_date1 from"  & rsCardEvent1 
    rstmpDATE1.Open sql33, Cn, adOpenStatic, adLockOptimistic

需要 SQL 查询帮助？

Answer 1

您可以在 SQL 中执行此操作并使用 SqlCommand 的 ExecuteNonQuery 方法：

sqlCardEvent = "select * " & _
    "into tmp_date1 " & _
    "from tmp_CARDEVENT"
cmdCardEvent1.CommandText = sqlCardEvent
cmdCardEvent.ExecuteNonQuery