提示:
消息 102,级别 15,状态 1,过程 p_iuser,第 13 行
'end' 附近有语法错误。SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROCEDURE [dbo].[p_iuser] (@user_name char(12))
as
begin
select @user_name=max(user_name) from t_user
if @user_name is null
begin
set @user_name='1122900'+'00001' -- 这一行的行号是13
end
else
begin
set @user_name=left(@user_name,7)+right('00000'+ltrim((right(@user_name,5)+1)),5)
end
go
消息 102,级别 15,状态 1,过程 p_iuser,第 13 行
'end' 附近有语法错误。SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROCEDURE [dbo].[p_iuser] (@user_name char(12))
as
begin
select @user_name=max(user_name) from t_user
if @user_name is null
begin
set @user_name='1122900'+'00001' -- 这一行的行号是13
end
else
begin
set @user_name=left(@user_name,7)+right('00000'+ltrim((right(@user_name,5)+1)),5)
end
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROCEDURE [dbo].[p_iuser] (@user_name char(12))
as
begin
select @user_name=max(user_name) from t_user
if @user_name is null
begin
set @user_name='1122900'+'00001' -- 这一行的行号是13
end
else
begin
set @user_name=left(@user_name,7)+right('00000'+ltrim((right(@user_name,5)+1)),5)
end
end --少个end
go