Syntactic Confectionery Delight | |
PerlMonks |
T-SQL problem - Perl solution?by Win (Novice) |
on Oct 25, 2004 at 10:46 UTC ( [id://402189]=perlquestion: print w/replies, xml ) | Need Help?? |
Win has asked for the wisdom of the Perl Monks concerning the following question:
My MS SQL Server 7 code snippet was something like:
If object_id(“table_name”) is not null begin … end This does not work for MS SQL Server 2000. So I tried something along the lines of: if (SELECT COUNT(*) FROM #Experimental_parameters) <> 0 begin DROP TABLE Experimental_parameters end The problem is that this updated solution requires the existence of the table. So it is not the same thing as the first. I am activating this with a Perl script. Maybe there is not a T-SQL solution for this, in which case I will need a Perl work around. Any suggestions would be welcome, even though I know that this is not really a Perl question.
Back to
Seekers of Perl Wisdom
|
|