create procedure sp_test(@mobile varchar(20),@order varchar(100))
as
begin
if exists(select 1 from my_send where mobile=@mobile)
begin
select * from my_Article where Articleid=@order
end
else
begin
insert into my_send(mobile,Articleid) select @mobile,@order
select teacher_content from my_teacher where Articleid=@order
end
end
go
--类似这样?
create proecdure sp_test(@mobile varchar(20),@order int)
as
begin
if @order=1
select * from my_Article where ...
if @order=2
select * from my_teacher where ...
if @order=3
select * from my_send where mobile=@mobile ...
end
go
create procedure sp_test(@mobile varchar(20),@order varchar(100))
as
begin
--先判断my_send中是否存在mobile为@mobile的记录
if exists(select 1 from my_send where mobile=@mobile)
begin
--存在,根据@order读取my_Article表中内容
select * from my_Article where Articleid=@order
end
else
begin
--不存在,my_send表插入@mobile和@order的值
insert into my_send(mobile,Articleid) select @mobile,@order
--根据@order读取相关表信息
if right(@order,1)='k'
select teacher_content from my_teacher where Articleid=@order
else
select * from my_Article where Articleid=@order
end
end
go
create procedure sp_test(@mobile varchar(20),@order varchar(100))
as
begin
if exists(select 1 from my_send where mobile=@mobile)
begin
select * from my_Article where Articleid=@order
end
else
begin
insert into my_send(mobile,Articleid) select @mobile,@order
if right(@order,1) = 'k'
select teacher_content from my_teacher where Articleid=@order
else
select content from my_Article where Articleid=@order
end
end
go
--有什么问题?
----------------------------------------------------------------------------------------------------------------------
create procedure sp_test(@mobile varchar(20),@order varchar(100))
as
begin
--先判断my_send中是否存在mobile为@mobile的记录
if exists(select 1 from my_send where mobile=@mobile)
begin
--存在,根据@order读取my_Article表中内容
select * from my_Article where Articleid=@order
end
else
begin
--不存在,my_send表插入@mobile和@order的值
insert into my_send(mobile,Articleid) select @mobile,@order
--根据@order读取my_Article表的content的内容
select teacher_content from my_teacher where Articleid=@order
end
end
go
先谢谢libin_ftsafe(子陌红尘)
create procedure sp_test(@mobile varchar(20),@order varchar(100))
as
begin
if exists(select 1 from my_send where mobile=@mobile)
begin
select * from my_Article where Articleid=@order
end
else
begin
insert into my_send(mobile,Articleid) select @mobile,@order
select teacher_content from my_teacher where Articleid=@order
end
end
go
这样解决不了,麻烦各位高人了!