ALTER PROCEDURE USP_BOARD_INSERT
-- Add the parameters for the stored procedure here
@table varchar(50)
, @thread int
, @type char(1)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
DECLARE @sql varchar(8000)
SET @sql = 'INSERT INTO ' + @table
SET @sql = @sql + ' ( thread, depth, type)'
SET @sql = @sql + 'SELECT ISNULL(MAX(thread),0)+100'
SET @sql = @sql + ' , 0'
SET @sql = @sql + ' , ''' + @type + '''' -- T or H
SET @sql = @sql + ' FROM ' + @table
EXEC(@sql)
-- SET @sql = 'SELECT MAX(thread) AS thread' -- 이 방법은 싫어요.
-- SET @sql = @sql + ' FROM ' + @table
-- EXEC(@sql)
위와 같은 구문이 있는데요. INSERT 구문상의 ISNULL(MAX(thread),0)+100 값을 리턴값으로 받고자하는데 방법이 없나요? |