1. 声明一个变量@tep(用declare),我怎么才能用select 返回的值填充到tep中去?就类似MS2000里面的:
select @tep = val from tb_Configure where key = '101' 我怎么才能把select 返回的值赋给tep?可以这样:declare tep int;
tep = (select val from tb_Configure where key='101');
select @tep = val from tb_Configure where key = '101' 我怎么才能把select 返回的值赋给tep?可以这样:declare tep int;
tep = (select val from tb_Configure where key='101');
转换到另外一种数据库,请好好看其文档,不要想当然的照搬旧的语法,否则真的会“搞死”