22,209
社区成员
发帖
与我相关
我的任务
分享
ALTER procedure [dbo].[usercheckee]
@infullname varchar(50),
@outcheck char(3) OUTPUT
as
if object_id("tempdb..#tabletest") in not null --提示列名tempdb..#tabletest无效
drop table #tabletest --如果临时表存在,删除临时表
if exists(select * from usra01 where A0101=@infullname)
begin--找出最大的张三,并分离出数字 并转化类型 再加1, 为了程序清晰,暂且放入临时表;
select cast(replace(max(A0101) ,@infullname,'') as decimal(18,0))+1 as num into #tabletest from usra01 group by A0101 where A0101 like @infullname --提示where附近语法错误
insert into usra01 name values (select 'num'+@infullname from #tabletest)
--values附近语法错误
select @outcheck='yes'
end
else
select @outcheck='no'
ALTER procedure [dbo].[usercheckee]
@infullname varchar(50),
@outcheck char(3) OUTPUT
as
if exists(select * from usra01 where A0101=@infullname)
select @outcheck='yes'
else
select @outcheck='no'