[Microsoft][ODBC SQL Server Driver][SQL Server]将数据类型 varchar 转换为 bigint 时出错。
2025-02-28 00:26:40
推荐回答(1个)
回答1:
rs_hy.Source = "SELECT * FROM tb_hy WHERE id_hy='"&request.QueryString("id")&"'" 改为: rs_hy.Source = "SELECT * FROM tb_hy WHERE id_hy=cast("&request.QueryString("id")&" as bigint)"