Question

Sql Server在存储过程中先判断数据库中是否存在table1，table2表,有就删除，没有就新建,只有30分了！

希望能够帮帮忙，万分感谢！
是在存储过程（proc）中执行，谢谢帮忙

Answer 1

--先判断存储过程是否存在
if exists(select * from sysobjects where name='存储过程名')
drop proc 存储过程名
go
CREATE PROC 存储过程名
--这里可以加参数
AS
IF EXISTS(SELECT * FROM sysobjects WHERE name='table1')
DROP TABLE table1
ELSE
CREATE TABLE table1(...)
IF EXISTS(SELECT * FROM sysobjects WHERE name='table2')
DROP TABLE table2
ELSE
CREATE TABLE table2(...)
GO

Answer 2

if object_id('Addon_Clear_StandaloneDB_raym') is not null
drop proc Addon_Clear_StandaloneDB_raym
go
Create PROCEDURE [dbo].[Addon_Clear_StandaloneDB_raym]
( @store_code varchar(20) , @dayleft int )

AS
...

这是一段例子，依葫芦画瓢就行了

Answer 3

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table1]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[table1](
字段

)
END

Answer 4

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[table1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[table1]
GO
CREATE TABLE table1 ……建表省略