Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 StoredProc

Author  Topic 

laforest
Starting Member

9 Posts

Posted - 2000-11-07 : 13:58:45
If one writes a stored procedure
1.) with a drop table statement

SQL SERVER will not let u create the stored proc
warning u that the particular table does not exist
if it is not there

So, you would need create some form of it

2) with a select into table statement
It will tell u that the table already exists (if it exists already)

Now, how does one create a stored proc with these
two above statements

drop table mytable

select * into mytable from oo

Thanks in advance!!

   

- Advertisement -