CREATE proc sp_getNewID
@TableName VARCHAR(50),@Length INT,@RETURNS VARCHAR(100) output
AS
.............
...........
exec('DECLARE Cur CURSOR FOR
SELECT id FROM '+@TableName+' ORDER BY id ASC')
...........
.........
set @RETURNS='结果'
END
@TableName VARCHAR(50),@Length INT,@RETURNS VARCHAR(100) output
AS
.............
...........
exec('DECLARE Cur CURSOR FOR
SELECT id FROM '+@TableName+' ORDER BY id ASC')
...........
.........
set @RETURNS='结果'
END
@TableName VARCHAR(50),@Length INT,@RETURNS VARCHAR(100) output
AS
.............
...........
exec('DECLARE Cur CURSOR FOR
SELECT id FROM '+@TableName+' ORDER BY id ASC')
...........
.........
set @RETURNS='结果'
END