资源描述：
《OA---数据库数据脚本.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、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,[TimeSta
2、rt][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])S
3、ETIDENTITY_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','2
4、012-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:
5、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-0
6、5-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]ifexists(select*fro
7、msysobjectswhereid=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,[
8、TimeEnd][datetime]NULL,[TimeTiXing][datetime]NULL,[TypeStr][varchar](50)NULL,[TimeStr][datetime]NULLDEFAULT(getdate()),[GongXiangWho][varchar](5000)NULL)ALTERTABLE[ERPAnPai]WITHNOCHECKADDCONSTRA
