begin try

DECLARE @column_name VARCHAR(100)
DECLARE @table_Name VARCHAR(100)
DECLARE @msg VARCHAR(500)
 
 SELECT @column_name= column_name
    ,@table_name=table_name 
 FROM INFORMATION_SCHEMA.COLUMNS WHERE  table_name = 'etc_pd' and column_name ='raw'
 IF @column_name = 'raw'
 BEGIN
  SET @msg= 'etc_pd has problem exit at this point'
  RAISERROR( @msg,11,1)
 END


 SELECT A into a 
END TRY

BEGIN CATCH
 SELECT  ERROR_MESSAGE() ,ERROR_LINE()  AS [Error Line]
END CATCH

begin try

DECLARE @column_name VARCHAR(100)
DECLARE @table_Name VARCHAR(100)
DECLARE @msg VARCHAR(500)
 
 SELECT @column_name= column_name
    ,@table_name=table_name 
 FROM INFORMATION_SCHEMA.COLUMNS WHERE  table_name = 'etc_pd' and column_name ='raw'
 IF @column_name IS NULL
 BEGIN
  SET @msg= 'etc_pd has problem exit at this point'
  RAISERROR( @msg,11,1)
 END


 SELECT A into a FROM etc_pd
END TRY

BEGIN CATCH
 SELECT  ERROR_MESSAGE() ,ERROR_LINE()  AS [Error Line]
END CATCH

quote:

---

Originally posted by aakcse

Thanks Sunita,

I have given Select a into a, intentional err stm; as I said that ,this will have list of column with a valid table only if the data file exists. if the file do not exists then also this stm will be there in the code, which can be allowed to fail and throw the user msg to front end.

But this was failing as, it was trying to compile first and throwing error. hence I made it dynamic to get it compiled at run time. and the control will go this stm by passing through the IF which allows the ctrl to pass only if it contains valid table name and columns names.

Regards,


-Neil

---