这个存储过程怎么运行不了?
CREATE PROCEDURE dbo.test
/* [ (@param_name datatype [= default] [output] ), ... ] */
AS
BEGIN
exec sp_addmessage 25001,"it is %1"
raiserror 25001,yan
return
END
报错:
Server Message: Number 225, Severity 16
Server 'WINSYBASE', Procedure 'sp_addmessage', Line 209:
Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.
Server Message: Number 2748, Severity 16
Server 'WINSYBASE', Procedure 'test', Line 6:
Message number 25001, passed to RAISERROR, does not exist in the sysusermessages catalog.
(return status = -6)
另外还有个问题:你们写SYBASE的存储过程用什么工具?我发现CENTRAL不好用,存过的存储过程不能再编辑。