SQL ServerÀィORACLEÁ´½Ó·þÎñÆ÷µÄͼ½â
Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
°²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â£¬µÇ½½çÃæÈçÏÂͼ£º
Êý¾Ý¿âµÄÏÂÀ¿ò£¬¾ÍÊÇnet·þÎñÃû£¬oracleµÄ³£¹æÕ˺ţ¬ÓÐĬÈϵÄÃÜÂ룬µ±È»£¬×Ô¼º¿ÉÒÔ¸ü¸ÄÃÜÂ룬ÔÚÉÏÃæÊý¾Ý¿âÅäÖÃÖúÀíÀï¿ÉÒÔ¸ÄÃÜÂ룬Ëø¶¨ÆäËûµÄһЩĬÈÏÕ˺ŵȣ¬ÓÐʱ£¬Õâ¸ö½çÃæµÇ½Ìáʾ ¼àÌýɶµÄûÆô¶¯£¬ÕâʱÐèÒªÔËÐÐservices.msc£¬À´Æô¶¯oracleµÄ¼àÌý·þÎñ¡£
ÏÖÔÚÕýÊÇ˵ÔõôÔÚÁ´½Ó·þÎñÆ÷ÉÏ×öoracleµÄÁ´½Ó·þÎñÆ÷£¬¼ÆËã»úÉÏÐèҪװÉÏmssqlºÍoracle£¬²¢ÅäÖúÃoracleµÄ·þÎñÃû£¬È»ºó£º
Á¬½Ó·þÎñÆ÷ÊÇ×Ô¼ºËæ±ã¶¨µÄ£¬Ìṩ³ÌÐòÃû³Æ±ØÐëÑ¡¶Ô£¬Êý¾ÝÔ´¾ÍÊǸոÕÅäÖúõÄoracle·þÎñÃû£¨oracleµÄ·þÎñÃûÒ»°ãÊÇÊý¾Ý¿â£¬ÓÐʱ¿ÉÒÔÖØÃüÃû·þÎñÃû£¬µ«¶ÔÓ¦µÄÊý¾Ý¿â²»±ä£¬ËùÒÔºóÃæµÄÕ˺ÅÃÜÂëÒªÌîд¶Ô£©
È»ºóÔÚ°²È«ÐÔÀÌîдoracleÖÐÄǸöÊý¾Ý¿â¶ÔÓ¦µÄµÇ½Õ˺ţ¬ÃÜÂëµÈ£º
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
Î壺 ORACLEµÄÖ´Ðмƻ®
±³¾°ÖªÊ¶£ºÎªÁ˸üºÃµÄ½øÐÐÏÂÃæµÄÄÚÈÝÎÒÃDZØÐëÁ˽âһЩ¸ÅÄîÐÔµÄÊõÓ
¹²ÏísqlÓï¾ä
ΪÁ˲»Öظ´½âÎöÏàͬµÄSQLÓï¾ä(ÒòΪ½âÎö²Ù×÷±È½Ï·Ñ×ÊÔ´£¬»áµ¼ÖÂÐÔÄÜϽµ)£¬ÔÚµÚÒ»´Î½âÎöÖ®ºó£¬ORACLE½«SQLÓï¾ä¼°½âÎöºóµÃµ½µÄÖ´Ðмƻ®´æ·ÅÔÚÄÚ´æÖС£Õâ¿éλÓÚϵͳȫ¾ÖÇøÓòSGA(system global are ......
Êý¾Ý¿âËùÓÐÕß (DataBase Owner)
dbo ÊǾßÓÐÔÚÊý¾Ý¿âÖÐÖ´ÐÐËùÓлµÄ°µÊ¾ÐÔȨÏÞµÄÓû§¡£½«¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±¶¼Ó³É䵽ÿ¸öÊý¾Ý¿âÄÚ³ÆΪ dbo µÄÒ»¸öÌØÊâÓû§ÉÏ¡£ÁíÍ⣬Óɹ̶¨·þÎñÆ÷½ÇÉ« sysadmin µÄÈκγÉÔ±´´½¨µÄÈκζÔÏó¶¼×Ô¶¯ÊôÓÚ ......
¡¡¡¡±¾ÎÄʾÀýÔ´´úÂë»òËزÄÏÂÔØ
¡¡¡¡±¾½ÚµÄÄÚÈÝ£º
¡¡¡¡ÈçºÎÔÚInfoPathÖÐʹÓÃÊý¾ÝÁ¬½ÓÀ´´ÓSQL ServerÊý¾Ý¿âÖлñÈ¡Êý¾Ý
¡¡¡¡ÈçºÎͨ¹ý´úÂëÀ´ÐÞ¸ÄÊý¾ÝÁ¬½ÓÖеÄSQL²éѯ
¡¡¡¡ÔÚ¿ªÊ¼Éè¼ÆInfoPath±íµ¥Ö®Ç°£¬ÏÈ×¼±¸Ò»¸öÊý¾Ý¿â£¬InfoPathÖ§³ÖÁ½ÖÖÊý¾Ý¿âÁ¬½Ó£º
¡¡¡¡Microsoft Office AccessÊý¾Ý¿â£¨.mdbÎļþ»ò.accdbÎļþ£©
¡¡¡ ......
--Èç¹û´æÔÚÊý¾Ý¿âprogrammerPay ¾Íɾ³ý
if exists (select * from sysdatabases where name='programmerPay')
drop database programmerPay
go
--´´½¨Êý¾Ý¿âprogrammerPay
create database programmerPay
on primary
(
name ='programmerPay_data',
filename='D:\programmerPay\programmerPay_data.mdf',
......