话不多说上代码
ALTER PROCEDURE [dbo].[P_InsertUserInfo]
(
@userCode nvarchar(20),
@userName nvarchar(50),
@userType int
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @exec_sql nvarchar(1999) = '';
declare @temp_index nvarchar(50) = '';
if(OBJECT_ID('tb_User','u') is not null)
begin
INSERT INTO tb_User(UserCode,UserName,UserType)VALUES(@userCode,@userName,@userType);
end
else
begin
select @temp_index = NEWID();
set @exec_sql += 'CREATE TABLE [dbo].[tb_User](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserCode] [varchar](20) NOT NULL,
[UserName] [nvarchar](20) NOT NULL,
[UserType] [int] NOT NULL,
[CreateDate] [datetime] DEFAULT getdate() NULL,
[CreateBy] [nvarchar](20) NULL,
CONSTRAINT ['+@temp_index+'] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]';
exec SP_EXECUTESQL @exec_sql;
INSERT INTO tb_User(UserCode,UserName,UserType)VALUES(@userCode,@userName,@userType);
end
END