ifexists(select*fromsysobjectswhereid=OBJECT_ID('[ERPAnPai]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[ERPAnPai]CREATETABLE[ERPAnPai]([ID][int]IDENTITY(1,1)NOTNULL,[UserName][varchar](50)NULL,[TitleStr][varchar](500)NULL,[ContentStr][text]NULL,[TimeStart][datetime]NULL,[TimeEnd][datetime]NULL,[TimeTiXing][datetime]NULL,[TypeStr][varchar](50)NULL,[TimeStr][datetime]NULLDEFAULT(getdate()),[GongXiangWho][varchar](5000)NULL)ALTERTABLE[ERPAnPai]WITHNOCHECKADDCONSTRAINT[PK_ERPAnPai]PRIMARYKEYNONCLUSTERED([ID])SETIDENTITY_INSERT[ERPAnPai]ONINSERT[ERPAnPai]([ID],[UserName],[TitleStr],[ContentStr],[TimeStart],[TimeEnd],[TimeTiXing],[TypeStr],[GongXiangWho])VALUES(20,'admin','举行公司内部例会，要准时参加','准时参加单位内部例会，通知其他参会人员，外派人员也要同时参加。','2012-03-109:00:00','2012-03-1012:00:00','2012-03-100:00:00','单位事务','待处理')INSERT[ERPAnPai]([ID],[UserName],[TitleStr],[ContentStr],[TimeStart],[TimeEnd],[TimeTiXing],[TypeStr],[TimeStr],[GongXiangWho])VALUES(21,'admin','营销课程培训，按照要求参加','单位营销课程培训，需要全体人员参加，提前准备资料。','2012-04-1813:00:00','2012-04-1815:00:00','2012-04-180:00:00','个人事务','2012-02-2915:59:13','待处理')INSERT[ERPAnPai]([ID],[UserName],[TitleStr],[ContentStr],[TimeStart],[TimeEnd],[TimeTiXing],[TypeStr],[TimeStr],[GongXiangWho])VALUES(22,'admin','客户现场处理问题，同时联系驻点工程师','及时去客户现场处理问题，联系驻点工程师一起前往。','2012-05-218:00:00','2012-05-2117:00:00','2012-05-210:00:00','单位事务','2012-02-2916:00:37','待处理')SETIDENTITY_INSERT[ERPAnPai]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[ERPBaoJia]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[ERPBaoJia]CREATETABLE[ERPBaoJia]([ID][int]IDENTITY(1,1)NOTNULL,[CustomName][varchar](100)NULL,[BaoJiaTitle][varchar](500)NULL,[BaoJiaType][varchar](500)NULL,[BaoJiaJinE][varchar](500)NULL,[BaoJiaContent][varchar](8000)NULL,[BaoJiaResult][varchar](5000)NULL,[BaoJiaTime][varchar](500)NULL,[BackInfo][varchar](8000)NULL,[UserName][varchar](50)NULL,[TimeStr][datetime]NULLDEFAULT(getdate()),[IFShare][varchar](5000)NULL,[CusBakA][varchar](