sql 创建表、存储过程、函数 时，判断已存在

以下适用于sqlserver 2008 R2

创建表：  

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MyTable]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[MyTable]
GO

CREATE TABLE [dbo].[MyTable](
    [Id] int IDENTITY(1, 1)
   ,[MyColumn] nvarchar(100) NOT NULL
) ON [PRIMARY]

创建存储过程：

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyProcedure]') AND type in (N'P', N'PC')) 
DROP PROCEDURE [dbo].[MyProcedure]
GO

CREATE PROCEDURE [dbo].[MyProcedure]
AS
    SELECT *
    FROM   MyTable

创建函数：

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyFunction]') AND type  = N'FN') 
DROP FUNCTION [dbo].[MyFunction]
GO

CREATE FUNCTION [dbo].[MyFunction]
(
	@Param1 nvarchar(500) ,
	@Param2 int
)
RETURNS int
AS
BEGIN
    RETURN 0
END