Ӧ
Computer Applications
1999 198 Vol.19No.8 1999



һǨߵƺʵ

ժҪVFPǨ򵼵ľԣĽһԶǨߵĹܽṹƷʵֹ̡
ؼʡSQL洢̣MIS
1
Mircosoft SQL Server ΪWindows NT ϵͳݿӦרƵ,Ϊݴĺ̨,ֺ˿߰ȫԺ³,ʵǿݹ,ٶȿ,ʱ䡣ݴ洢ռɷ䣬ݴʵʱԺԶݴVisual FoxPro (VFP) SQL Serverǻƽ,ֱ֧غԶͼҿԽͼ뱨ϵ,ڳЧ,̡ܼˣVFPSQL ServerԽԽ㷺رѡΪϢϵͳǰ˿ߺݿϵͳ
ΪˣVFPͽṹѯԿһǨߡ vuprise


ͼ1vupriseĹܽṹ
ͼ1ΪvupriseĹܽṹʾͼ
2vupriseʵ
vupriseʵȽ̨ݿͺ̨ĸǨԶ嵽رУȻͨVFPṩSQL pass-throughʵֽЩԴSQL Serverϡֱֵܸƺʵֹ̡
2.1ṹά
ṹ޸ıṹɾų̃́ժ̨ȹܡṹϢ洢ڱرtablefldУṹ£
ֶΡֶ͡ȡע
1TABLENAMEC16
2FIELDNAMEC16ֶ
3DATATYPEC16ֶͼ
4NULLFLAGL1Ƿؼֶ
5DEFAVALUEC10Ĭֵ
6CHECKC40ϷԼʽ
7FLDMEMOC60ֶ˵
TABLENAMEFIELDNAMEDATATYPEDEFAVALUECHECKϢĶ嶼Transact-SQLľ䷨糤Ϊ4ֶַͼDATATYPEΪChar(4)µĺ̨£ͨṹܶṹϢȻѡ񴴽̨̨ܽ޸ĺ̨Ľṹʱͨ޸ıṹ޸ıĽṹϢȻѡ񴴽̨ܶԺ̨ṹά˹ֺ̨ܱԭݲʧ
Ǩһ±ʱ̨ͨCREATE TABLEɹ±дǨһ̨Ѵڵıк̨ṹάʱΪ˱̨֤ԭϢʧǨɹһһԭԶͼͨͼ̨صʱб棻ڶԣԭֶ̨Ϊ룬ժԣժԭ̨ȻCREATE TABLE½ṹĺ̨Ĳָ̨ԭݼԡ̨ͨDROP TABLEժ̨
2.2ά
Ժ̨άժȹܡйϢ洢ڱرtableidxУṹ£
ֶΡֶ͡ȡע
1TABLENAMEC16
2INDNAMEC16
3FIELDLISTC80ʽ
4CLUSTERL1Ƿ
5UNIQUEL1ǷΨһ
INDNAMEʽFIELDLISTĶTransact-SQLľ䷨к̨άʱȶйϢȻѡ񴴽̨ܽ
ժֱ̨ͨCREATE INDEXDROP INDEXʵ֡
2.3Զ
Կһԣǲͬؼֺⲿؼ֮ϵĹ򡣲Զɽ֮ϵƼ¼رеĲ롢»ɾϵйϢ洢ڱرtablerltУṹ£
ֶΡֶ͡ȡע
1TABLENAMEC16
2FORKEYNAMEC16
3FIELDLISTC80ֶ
4PARTABNAMEC16ձ
5PARKEYFLDC80ֶ
FORKEYNAMEĶTransact-SQLľ䷨вԶʱȶϵϢȻѡ񴴽빦̨֮ܽϵ
ժԷֱ̨ͨALTER TABLE ADD CONSTRAINTALTER TABLE DROP CONSTRAINTʵ֡
2.4洢̴
SQL SERVERУ洢Ǳһݿһµ伯ϡں̨ô洢ʵһЩʱصصԽԣߴЧʡ洢ǾԤȶͱζͨSQL䲻ͬ״һ洢ʱSQL SERVERĲѯ﷨ų˴֮γɴ洢ϵͳеĿִз´ִʱͲҪٽִٶȽϿ죻洢̺ʹݶͬһ̨SQL SERVERϣݿϵͳ洢͹Щ洢̣ЧȻߣ洢̵ĵһɿͻͨ洢ãϴֻǹͲγɴ洢̵SQL䴮Ĵ洢̾кԣβκͷֵʱӦ滮Щڿͻʵַ㣬Щں̨ʵַ㡣洢̶йϢ洢ڱرtableproУṹ£
ֶ ֶ   ע
1PROCNAMEC20洢
2PROCPARAC100洢̲
3PROCSQLM4ɴ洢̵SQL
4CREFLAGL1ǷѴ
PROCNAMEPROCPARAPROCSQLĶ嶼Transact-SQL䷨洢ʱȶ洢̵ϢȻѡ񴴽ܼɴ洢̵̨ݿС
ժ̨ݿ洢̷ֱͨCREATE PROCEDURE DROP PROCEDUREʵ֡
2.5
SQL SERVERУһĴ洢̣ݿһеһµSQL伯ϡڱĲ롢»ɾ֮ԶСǿ񼶹ԡпͨܵ͡йϢ洢ڱرtabletriУṹ£
ֶ ֶ   ע
1TRINAMEC20
2TABLENAMEC16Ӧĺ̨
3TRISETC20ͼ
4TRISQLM4ɴSQL
5CREFLAGL1ǷѴ
TRINAMETRISET TRISQLĶTransact-SQL䷨TRISETΪ{INSERT,UPDATE,DELETE}Ӽʱȶ崥ϢȻѡ񴴽ܼɴ̨С
ժֱ̨ͨCREATE TRIGGER DROP TRIGGERʵ֡
3
ϵͳʵݿṹȵǨܣΪṩһάߡرϵͳн׶ΣĿû֮ͨź蹵ϵͳĲȶԣԱṹάȽϴͨvupriseǨߣάԱֱǰ̨ݣͨSQL򵽺̨SQL ServerϽвǿϵͳݵİȫԡ⣬ں̨ݿͱǨԶڱرУϵͳɺĵͳһƺǽùڶϢϵͳʵ֤ϵͳVFPṩǨ߸Ϊʵá
ߵλ١Ϸʹҵѧо.Ϸ(230009)
ο
1ݡ.Visual FoxPro 5.0߼ָ.磬1998,4
2ݡMicrosoft.Microsoft SQL Server 6.5 Transact-SQLοָ.ѧ磬1997,8
3ݡպ.ISеݿ.ʮȫϢϵͳѧļ.еҵ磬1998.10,3:7
ո:1999-02-19
