SQL存储过程改为ACCESS查询语句
ALTER   PROCEDURE   GetDepartmentDetails
(
@DepartmentID   int,
@DepartmentCnName   nvarchar(50)   OUTPUT,
@DepartmentName   nvarchar(50)   OUTPUT,
@DepartmentDescription   nvarchar(200)   OUTPUT
)
AS

SELECT   @DepartmentCnName=[CnName],   @DepartmentName=[Name],   @DepartmentDescription=[Description]
FROM   Department
WHERE   DepartmentID   =   @DepartmentID

RETURN


------解决方案--------------------
SELECT [CnName], [Name], [Description]
FROM Department
WHERE DepartmentID = ？

*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)

最新版本：20070130

http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html