摘要:
create proc getID(@out_next_id char(4) output)asbegin declare @temp int if((select count(*) from table_name)=0) begin set @out_next_id = 'A100' end else begin select @out_next_id=max(field_name) from table_name set @temp = right(@out_next_id,3)+1 s 阅读全文
posted @ 2011-02-21 11:04
点灯
阅读(242)
评论(1)
推荐(0)
浙公网安备 33010602011771号