怎样建立临时表？？

[boredom_vc]

怎样建立临时表？？并跟crystal report一起用！！

[wangbm]

sql建立临时表中：
create #tmptable
crystal report一起用：
在VB中传入记录集
或用存储过程

[lxqlogo0]

create #tmptable

[TaoHuang]

dim sql as string
SQL = SQL & "CREATE TABLE #TempTbl ("
SQL = SQL & " [field1] [char] (12) NULL ,"
SQL = SQL & " [field2] [nvarchar] (100) NULL ,"
SQL = SQL & " [field3] [char] (6) NULL)"
SQL = "if not (select object_id('Tempdb..#TempTbl')) is null drop table #TempTbl;" & SQL
g_cnnMain.Execute l_SQL
新增資料入臨時表后，同其他數據表一樣用法。建個Recordset打開臨時表，再同水晶報表連接。

[boredom_vc]

我是用Mysql的

[junwhj]

up

[hc_z]

Create Table #DCDeviceDayTmpTable
(DataTime datetime,
DataVal float
)

[馮強]

教你一招，在内存中建立临时表的方法。前题是不要太多记录，几万条的话，还是老老实实在SQL-Server中建表。

利用ADO的RecordSet在内存中建立临时表的方法。

Dim rs as New Adodb.RecordSet

rs.Fields.Append "Name", adBSTR, 20
rs.Fields.Append "Age", adInteger
rs.Fields.Append "Degree", adBSTR, 50
rs.CursorType = adOpenStatic
rs.LockType = adLockOptimistic

rs.Open

Dim i As Integer

For i = 1 To 100

rs.AddNew
rs!name = "Name " & i
rs!Age = i
rs!Degree = "本科"
rs.Update

Next

rs.MoveFirst

Set DataGrid1.DataSource = rs

试试吧，Good Luck!