假如存储过程TEST带2个参数Create proc test
@t1 varchar(256),
@t2 varchar(256)
as
begininsert into tbl values(@t1,@t2)
end我怎么判断T1和T2的值不为空,然后在向表tbl里插数据
@t1 varchar(256),
@t2 varchar(256)
as
begininsert into tbl values(@t1,@t2)
end我怎么判断T1和T2的值不为空,然后在向表tbl里插数据
@t1 varchar(256),
@t2 varchar(256)
as
begin
IF @T1 IS NOT NULL AND @T2 IS NOT NULL
insert into tbl values(@t1,@t2)
end
@t1 varchar(256),
@t2 varchar(256)
as begin
if len(ltrim(rtrim(@t1)))>0 and len(ltrim(rtrim(@t2)))>0
insert into tbl values(@t1,@t2)
end
@t1 varchar(256),
@t2 varchar(256)
as begin
if len(ltrim(rtrim(@t1)))>0 and len(ltrim(rtrim(@t2)))>0
insert into tbl values(@t1,@t2)
endcreate TABLE tbl(COL1 VARCHAR(10),COL2 VARCHAR(10))EXEC TEST '',''
EXEC TEST '1',''
EXEC TEST '1','2'SELECT * FROM tbl/**
COL1 COL2
---------- ----------
1 2(所影响的行数为 1 行)
**/
@t1 varchar(256),
@t2 varchar(256)
as
begin
IF len(@t1)>0 and len(@t2)>0
insert into tbl values(@t1,@t2)
end
假如2个参数是空的,我要向另一个表插数据,
Create proc test
@t1 varchar(256),
@t2 varchar(256)
as begin
if len(ltrim(rtrim(@t1)))>0 and len(ltrim(rtrim(@t2)))>0
insert into tbl values(@t1,@t2)
else
insert into 另一个表 values(数据)
end