Declare @contract_id numeric
select @contract_id = max(contract_id) from contract_info --想把最大的ID赋值给这个参数,然后执行下面的语句
insert into con_payment values(@contract_id,@pay_date,@pay_money,@payment_id, '1 ')
select @contract_id = max(contract_id) from contract_info --想把最大的ID赋值给这个参数,然后执行下面的语句
insert into con_payment values(@contract_id,@pay_date,@pay_money,@payment_id, '1 ')
select @contract_id =select max(contract_id )from contract_info
insert into con_payment values(@contract_id,@pay_date,@pay_money,@payment_id, '1 ') max函数的用法
select @contract_id = 'select max (contract_id) from contract_info '//想把最大的ID赋值给这个参数,然后执行下面的语句
insert into con_payment values(@contract_id,@pay_date,@pay_money,@payment_id, '1 ')
这样不可以吗?