代码如下:
tp2不做修改最好,如必须做修改那修改越少越好
if exists(select 1 from sysobjects where name='tp1')drop proc tp1
if exists(select 1 from sysobjects where name='tp2')drop proc tp2
gocreate proc tp1
@param char
as
exec tp2 @param
/*if... */
--我想在这里判断,如果tp2中返回了至少一个结果集,就执行某一操作,应如何写?
gocreate proc tp2
@param char
as
select 1 from sysobjects where name=@param
go
tp2不做修改最好,如必须做修改那修改越少越好
if exists(select 1 from sysobjects where name='tp1')drop proc tp1
if exists(select 1 from sysobjects where name='tp2')drop proc tp2
gocreate proc tp1
@param char
as
exec tp2 @param
/*if... */
--我想在这里判断,如果tp2中返回了至少一个结果集,就执行某一操作,应如何写?
gocreate proc tp2
@param char
as
select 1 from sysobjects where name=@param
go
@param char
as
declare @t table(id int)
insert @t exec tp2 @param
if exists(select 1 from @t)
print '有結果集'
select 1 from sysobjects where name=@param
支持 用if else判断
@param char
as
select 1 from sysobjects where name=@param
if @@error = 0
return 0
else
return 1
gocreate proc tp1
@param char
as
declare @i int
select @I = exec tp2 @param
....go
不好意思,更正一下
create proc tp2
@param char
as
select 1 from sysobjects where name=@param
if @@error = 0
return 0
else
return 1
go create proc tp1
@param char
as
declare @i int
exec @I = tp2 @param
.... go
if exists(select 1 from sysobjects where name='tp2')drop proc tp2
gocreate proc tp1
@param char
as
exec tp2 @param
/*if... */
IF (SELECT COUNT(*) FROM TB )>0gocreate proc tp2
@param char
as
select 1 from sysobjects where name=@param
go
@param char
as
exec tp2 @param
if @@ROWCOUNT<>0
print '有结果'
go
@param char
as
exec tp2 @param
if @@ROWCOUNT<>0
print '有结果'
go
@param char
as
exec tp2 @param
if @@rowcount=0
--我想在这里判断,如果tp2中返回了至少一个结果集,就执行某一操作,应如何写?
go
create proc tp1
@param char
as
exec tp2 @param
if @@rowcount=0--一行都没有的情况
--我想在这里判断,如果tp2中返回了至少一个结果集,就执行某一操作,应如何写?
go
print '有结果'