CREATE PROCEDURE mysp_test
@id int,
@Content ntext output
as
begin
.....................
end
go
提示不能以ntext数据类型作为参数 ????
------解决方案--------------------
use @Content nvarchar(4000)
or return a recordset
eg:
CREATE PROCEDURE mysp_test
@id int
as
select content from tableName where id=@id
go