主题：拼接了一个sql语句如何传递到储存过程中生成临时表?

Dim cmd As New SQLCommand

cmd.ConnectionName = Mydata

cmd.CommandText = Exec usp_tbover '采购入库明细', '(Select ''CG1702-052'' as 来源单号,''A0106000280000'' as 产品编码,85 as 数量

)'

明白了,怎么把前面dim cmd as new 这些字符也传递进去了,晕!,可以啦,谢谢!

弹出的是这个？你这个在sql测试窗口测试，是否报错？

Exec usp_tbover '采购入库明细', '(Select ''CG1702-052'' as 来源单号,''A0106000280000'' as 产品编码,85 as 数量)'

晕死,只要传入

"Exec usp_tbover '采购入库明细', '(Select ''CG1702-052'' as 来源单号,''A0106000280000'' as 产品编码,85 as 数量)'"

就可以,从命令窗口复制时怎么全部都复制进去了

可以了.谢谢!