其他的内容不知道,不过你存储过程中不用使用getdate() 需要更改为如下:ALTER PROCEDURE [dbo].[P_DATA_COLLECT] @dt varchar(10) AS BEGIN SET NOCOUNT ON; INSERT INTO TEST(RQ,ZRS,ZJE,ZSL) VALUES(@dt,1,1) UPDATE TEST SET ZRS = (SELECT COUNT(1) FROM TABLE1), ZJE= (SELECT COUNT(1) FROM TABLE2), ZSL= (SELECT COUNT(1) FROM TABLE3) WHERE RQ = @dt END goexec P_DATA_COLLECT '2010-12-27'exec P_DATA_COLLECT convert(varchar(10),getdate(),120)
ALTER PROCEDURE [dbo].[P_DATA_COLLECT] AS BEGIN insert INTO TEST(RQ,ZRS,ZJE,ZSL) select * from ( ZRS = (SELECT COUNT(1) FROM TABLE1), ZJE= (SELECT COUNT(1) FROM TABLE2), ZSL= (SELECT COUNT(1) FROM TABLE3) WHERE RQ = GETDATE()) a END
需要更改为如下:ALTER PROCEDURE [dbo].[P_DATA_COLLECT] @dt varchar(10)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO TEST(RQ,ZRS,ZJE,ZSL) VALUES(@dt,1,1) UPDATE TEST SET
ZRS = (SELECT COUNT(1) FROM TABLE1),
ZJE= (SELECT COUNT(1) FROM TABLE2),
ZSL= (SELECT COUNT(1) FROM TABLE3)
WHERE RQ = @dt
END
goexec P_DATA_COLLECT '2010-12-27'exec P_DATA_COLLECT convert(varchar(10),getdate(),120)
ALTER PROCEDURE [dbo].[P_DATA_COLLECT]
AS
BEGIN
insert INTO TEST(RQ,ZRS,ZJE,ZSL)
select * from (
ZRS = (SELECT COUNT(1) FROM TABLE1),
ZJE= (SELECT COUNT(1) FROM TABLE2),
ZSL= (SELECT COUNT(1) FROM TABLE3)
WHERE RQ = GETDATE()) a
END