1.不支持top 1 可以使用limit order by
2.select语句给变量赋值的方式
--第一种写法
select into tempstorename, tempstorerankname storename, storerankname from tbasstoretest where cast(storeid as varchar) = storeidp;
--第二种写法
--sql := 'select storename, storerankname from tbasstoretest where cast(storeid as varchar) ='''|| storeidp||'''';
--execute sql into tempstorename,tempstorerankname;