如果语句单独执行很快,但是放到存储过程中很慢,那可能是执行计划搞的鬼试试
WITH RECOMPILE
关于存储过程级别的重编译,典型用法如下,在存储过程参数之后指定“WITH RECOMPILE”
CREATE PROCEDURE Pro_Test
(
@id int
)WITH RECOMPILE
AS
BEGIN
SELECT * FROM Test WHERE fId = @id ;
END
GO
如果语句单独执行很快,但是放到存储过程中很慢,那可能是执行计划搞的鬼试试
WITH RECOMPILE
关于存储过程级别的重编译,典型用法如下,在存储过程参数之后指定“WITH RECOMPILE”
CREATE PROCEDURE Pro_Test
(
@id int
)WITH RECOMPILE
AS
BEGIN
SELECT * FROM Test WHERE fId = @id ;
END
GO