how to judge if the temptable or normal table that you created exists

just as the following scripts shows:
1.temp table
    if exists (select * from sysobjects where objectproperty(object_id('TempTableName'),'istable') = 1)
2.normal table
   if object_id('tablename') is null

posted on 2008-01-17 09:20  飞天舞者  阅读(184)  评论(0编辑  收藏  举报

导航

For more information about me, feel free email to me winston.he@hotmail.com