use p_suspects
go
if object_Id('proc_insertCaseRecord') is not null
drop proc proc_insertCaseRecord
go
create proc proc_insertCaseRecord
(
@C_Name varchar (100),
@C_Leader varchar(50),
@C_Suspects varchar (50),
@C_Place varchar (50),
@C_Time datetime (8),
@C_Description varchar (1000),
)
as
if exists(select * from CaseRecord where C_Name=@C_Name)
begin
return 100
end
else
begin
insert into CaseRecord(CName,CLeader,CSuspects,CPlace,CTime,CDescription)
values(@C_Name,@C_Leader,@C_Suspects,@C_Place,@C_Time,@C_Description)
end
go我新建存储过程,复制过去后,检查语法说:”错误170:第9行“)”附近有语法错误“,这个是我用的一个没有任何错误的过程改了下列名而已,,,,
go
if object_Id('proc_insertCaseRecord') is not null
drop proc proc_insertCaseRecord
go
create proc proc_insertCaseRecord
(
@C_Name varchar (100),
@C_Leader varchar(50),
@C_Suspects varchar (50),
@C_Place varchar (50),
@C_Time datetime (8),
@C_Description varchar (1000),
)
as
if exists(select * from CaseRecord where C_Name=@C_Name)
begin
return 100
end
else
begin
insert into CaseRecord(CName,CLeader,CSuspects,CPlace,CTime,CDescription)
values(@C_Name,@C_Leader,@C_Suspects,@C_Place,@C_Time,@C_Description)
end
go我新建存储过程,复制过去后,检查语法说:”错误170:第9行“)”附近有语法错误“,这个是我用的一个没有任何错误的过程改了下列名而已,,,,
go
if object_Id('proc_insertCaseRecord') is not null
drop proc proc_insertCaseRecord
go
create proc proc_insertCaseRecord
@C_Name varchar (100),
@C_Leader varchar(50),
@C_Suspects varchar (50),
@C_Place varchar (50),
@C_Time datetime (8),
@C_Description varchar (1000),
@rtn int OUTPUT
as
begin
if exists(select * from CaseRecord where C_Name=@C_Name)
begin
return 100
end
else
begin
insert into CaseRecord(CName,CLeader,CSuspects,CPlace,CTime,CDescription)
values(@C_Name,@C_Leader,@C_Suspects,@C_Place,@C_Time,@C_Description)
end
end
go