dynamic if exists

[vasah20]

is it possible to do a dynamic IF EXISTS statement?

something along the lines of

CREATE PROCEDURE sp_blah
(
@tblName NVARCHAR(100)
)
AS
IF EXISTS sp_executesql N'SELECT this FROM ' & @tblName
...

any ideas to do this would be greatly appreciated.

thanks
leo

 

[tlbroadbent]

Try this... Modify as needed for your data types.

CREATE PROCEDURE sp_blah
(
@tblName NVARCHAR(100)
)
AS

Declare @sql varchar(1024)

Set @sql='Select TOP 1 this From ' + @tblName

Create table #t (this varchar(40))

Insert #t
exec(@sql)

if exists (Select * From #t)
Print 'good'
Else
Print 'bad'

drop table #t Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[rajeevnandanmishra]

Hi leo,

If you want to check the IF Exists dynamically, you can use the following code also. The difference is you don't have to create/drop a temporary table.
------------------------------
CREATE PROCEDURE sp_blah
(
@tblName NVARCHAR(100)
)
AS
declare @sql varchar(1024)
Set @sql='Select this From ' + @tblName
exec(@sql)
IF @@rowcount>0
Print 'EXIST'
ELSE
Print 'Not Exist'
------------------------------

May this help you!