医药CRM系统开发

自已做医药CRM系统有四年了,终于可以算个产品了,努力市场化,今年重种将医药营销的理念加入CRM

导航

CRM批注

Posted on 2007-03-20 17:28  hhq80  阅读(157)  评论(0编辑  收藏  举报

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_SchedulePostil]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CRM_SchedulePostil]
GO

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_SchedulePostil]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[CRM_SchedulePostil] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [CoScheduleTypeID] [varchar] (30) NOT NULL ,
 [Description] [varchar] (3000) NOT NULL ,
 [CreatorTypeID] [varchar] (30) NOT NULL ,
 [CreateDate] [datetime] NOT NULL
) ON [PRIMARY]
END

GO