高分求助!存储过程????
有如下存储过程:
CREATE PROCEDURE [PROCEDURE_NAME]
@start int,
@end int
AS
SELECT IDENTITY (int, 1, 1) AS iid, *
INTO #temp_result
FROM aaaa
DELETE FROM bbb_TEMP
INSERT INTO dba.K_STAT_TEMP(a,b ,c)
SELECT a,b,c
FROM #temp_result
where iid >= @start and iid<= @end;
在脚本中如下代码
long iid_start,iid_end
iid_start = 32
iid_end = 64
DECLARE k_proc PROCEDURE FOR dbo.PROCEDURE_NAME
@start= iid_start, @end = iid_end;
EXECUTE k_proc;
执行后报错:
Error converting data type nvarchar to int
不知是哪的问题
换成
int iid_start,iid_end
integer iid_start,iid_end
也不行