求sql?
create table tb_conf(
UserID varchar(20) primary key not null,
IP varchar(20) not null,
dates datetime
)
我想创建一个存储过程，
create procedure pro_tbconf
@IP varchar(20)
as
........
实现的功能就是先根据IP去表里查找UserID ，，
如果表中没有此Ip就插入新的一行。。
谢谢拉
[解决办法]
create procedure pro_tbconf
@IP varchar(20)
as
if exists( select use_id from tb_conf where ip=@ip)
select use_id from tb_conf where ip=@ip
else
insert into................
[解决办法]
create procedure pro_tbconf
@IP varchar(20)
as
if not exists (select * from tb_conf where ip=@ip)
insert into tb_conf(IP) select @ip
go
[解决办法]
create procedure pro_tbconf
@IP varchar(20)
if not exists (select ip from tb_conf where ip = @ip)
insert into tb_conf(userid,ip,dates) values(....)
as
[解决办法]
create procedure pro_tbconf
@IP varchar(20)
as
if not exists (select ip from tb_conf where ip = @ip)
insert into tb_conf(userid,ip,dates) values(....)
go
[解决办法]
哈哈,终于沙发 ,不过我理解的和牛人们理解有点偏差...
