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