如何把查询到的数据附给某个变量？SQL语句怎么写？

[JIMIPAGE]

我想从数据库中查询出某数据，然后把它附给某个变量！该怎么写SQL语句？

[CrazyFor]

set @变量=(select .....这里只能有一条记录)


or

select @变量=字段,@变量1=字段1 from 表 ---只能有一条记录返回

[JIMIPAGE]

这么写可以吗？
select ImageDescription into re from ImageStore where ImageID ='" & id1 & "' "

[dafu71]

其实可以这样
rs.open "select ImageDescription from ImageStore where ImageID ='" & id1 & "' "
response.write rs(0)

[JIMIPAGE]

但是我想把取到的值付给某个变量！

[zosky]

set @变量=(select .....这里只能有一条记录)
就是把取到的值付给某个变量！

[JIMIPAGE]

dim re as string
Dim strSql as string = "set @re=(select ImageDescription into re from ImageStore Where ImageID=23)"

[JIMIPAGE]

我是用。NET做的

[TaoGeGe]

用.net做也一樣的。

首先，你可以用recordset在程序裡面執行一個SQL語句，得到一個記錄集形式的返回值，
然後用一個變量得到返回記錄集指定字段的value.

[JIMIPAGE]

Public Sub Page_Load(Sender As Object,E As EventArgs)

Dim strConnection as String = "user id=sa;password=;"
strConnection += "database=northwind;server=jet-server;"
strConnection += "Connect Timeout=30"

Dim re As String
Dim strSql as string = "Select ImageDescription From ImageStore Where ImageID=23"

Dim objConnection as New SqlConnection(strConnection)
Dim objCommand as new SqlCommand(strSql,objConnection)

objConnection.Open()

objCommand.ExecuteNonQuery()

message.text = objCommand.Item("0")
？这最后一行怎么写啊？我想把查询得到的值附给message.text