【vfp开源代码栏目提醒】:网学会员vfp开源代码为您提供CreateStoreProc.prg参考,解决您在CreateStoreProc.prg学习中工作中的难题,参考学习。
LOCAL cQuery,nResult
cQuery="CREATE PROCEDURE p_productcount "+;
"@ProductId INT, "+;
"@StartDate DATETIME, "+;
"@EndDate DATETIME, "+;
"@QtySold INT OUTPUT "+;
"AS "+;
"SELECT @QtySold=SUM(od.Quantity) "+;
"FROM Orders o INNER JOIN [Order Details] od "+;
"ON o.OrderId=od.OrderId "+;
"WHERE od.ProductId=@ProductId "+;
"AND o.OrderDate BETWEEN @StartDate AND @EndDate "
nHandle=SQLSTRINGCONNECT("Driver=SQL Server;Server=CCB-ZHJ;"+;
"UID=sa;PWD=;Database=Northwind")
nResult=SQLEXEC(nHandle,cQuery)