Avatar of tanu80

asked on 

replacing old datatable in sql server 2005

i am  creating a temp table in the database.First time when i am executing the query it is not making any problem , but second time when i am executing the  query  i am getting the message like
Server: Msg 2714, Level 16, State 6, Line 13
There is already an object named '##TempData11' in the database.
  socan any one help me how to check the database that whether the table is present or not , if present then drop the table and then again create the table
Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon