数据库中建了一个存储过程,在vb.net中怎样调用它create proc Invertory
as
If Object_Id('Tempdb.dbo.#temp') Is Not Null
Begin
drop table #temp
End
as
If Object_Id('Tempdb.dbo.#temp') Is Not Null
Begin
drop table #temp
End
sql = "select [card_name],[card_type],[card_start],[card_end],SUM(t*card_number) 库存量 from(select *,case when card_flow='入库' then 1 else -1 end T from [Esa_Web_Opr_New].[dbo].[cardManage])A group by card_name,card_type,card_start,card_end"这一条语句的库存量想存入变量,怎样实现,有人说用存储过程
Set cmdProcedure.ActiveConnection = m_objConn
cmdProcedure.CommandTimeout = 300
cmdProcedure.CommandText = Trim$(strProcedureName) ---Procedure Name
cmdProcedure.CommandType = adCmdStoredProc
cmdProcedure.Parameters.Refresh With cmdProcedure ...... .Execute End With
* dawugui
* (爱新觉罗.毓华)
*
* 等 级:
declare @sum intsql = "select [card_name],[card_type],[card_start],[card_end],'+@sum+'=SUM(t*card_number) 库存量 from(select *,case when card_flow='入库' then 1 else -1 end T from [Esa_Web_Opr_New].[dbo].[cardManage])A group by card_name,card_type,card_start,card_end"exec(sql)
--或者
select [card_name],[card_type],[card_start],[card_end],@sum=SUM(t*card_number) 库存量 from(select *,case when card_flow='入库' then 1 else -1 end T from [Esa_Web_Opr_New].[dbo].[cardManage])A group by card_name,card_type,card_start,card_endselect @sum
其他楼是sql server中的。
sqlserver: exec "名称"