Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL ServerÀィORACLEÁ´½Ó·þÎñÆ÷µÄͼ½â

 Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
  °²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â£¬µÇ½½çÃæÈçÏÂͼ£º
Êý¾Ý¿âµÄÏÂÀ­¿ò£¬¾ÍÊÇnet·þÎñÃû£¬oracleµÄ³£¹æÕ˺ţ¬ÓÐĬÈϵÄÃÜÂ룬µ±È»£¬×Ô¼º¿ÉÒÔ¸ü¸ÄÃÜÂ룬ÔÚÉÏÃæÊý¾Ý¿âÅäÖÃÖúÀíÀï¿ÉÒÔ¸ÄÃÜÂ룬Ëø¶¨ÆäËûµÄһЩĬÈÏÕ˺ŵȣ¬ÓÐʱ£¬Õâ¸ö½çÃæµÇ½Ìáʾ ¼àÌýɶµÄûÆô¶¯£¬ÕâʱÐèÒªÔËÐÐservices.msc£¬À´Æô¶¯oracleµÄ¼àÌý·þÎñ¡£
ÏÖÔÚÕýÊÇ˵ÔõôÔÚÁ´½Ó·þÎñÆ÷ÉÏ×öoracleµÄÁ´½Ó·þÎñÆ÷£¬¼ÆËã»úÉÏÐèҪװÉÏmssqlºÍoracle£¬²¢ÅäÖúÃoracleµÄ·þÎñÃû£¬È»ºó£º
Á¬½Ó·þÎñÆ÷ÊÇ×Ô¼ºËæ±ã¶¨µÄ£¬Ìṩ³ÌÐòÃû³Æ±ØÐëÑ¡¶Ô£¬Êý¾ÝÔ´¾ÍÊǸոÕÅäÖúõÄoracle·þÎñÃû£¨oracleµÄ·þÎñÃûÒ»°ãÊÇÊý¾Ý¿â£¬ÓÐʱ¿ÉÒÔÖØÃüÃû·þÎñÃû£¬µ«¶ÔÓ¦µÄÊý¾Ý¿â²»±ä£¬ËùÒÔºóÃæµÄÕ˺ÅÃÜÂëÒªÌîд¶Ô£©
 
È»ºóÔÚ°²È«ÐÔÀÌîдoracleÖÐÄǸöÊý¾Ý¿â¶ÔÓ¦µÄµÇ½Õ˺ţ¬ÃÜÂëµÈ£º


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......

ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL(ËÄ)

Î壺 ORACLEµÄÖ´Ðмƻ®
±³¾°ÖªÊ¶£ºÎªÁ˸üºÃµÄ½øÐÐÏÂÃæµÄÄÚÈÝÎÒÃDZØÐëÁ˽âһЩ¸ÅÄîÐÔµÄÊõÓ
 
¹²ÏísqlÓï¾ä
 
ΪÁ˲»Öظ´½âÎöÏàͬµÄSQLÓï¾ä(ÒòΪ½âÎö²Ù×÷±È½Ï·Ñ×ÊÔ´£¬»áµ¼ÖÂÐÔÄÜϽµ)£¬ÔÚµÚÒ»´Î½âÎöÖ®ºó£¬ORACLE½«SQLÓï¾ä¼°½âÎöºóµÃµ½µÄÖ´Ðмƻ®´æ·ÅÔÚÄÚ´æÖС£Õâ¿éλÓÚϵͳȫ¾ÖÇøÓòSGA(system global are ......

SQLÖÐdbo.

Êý¾Ý¿âËùÓÐÕß  (DataBase Owner)
dbo   ÊǾßÓÐÔÚÊý¾Ý¿âÖÐÖ´ÐÐËùÓлµÄ°µÊ¾ÐÔȨÏÞµÄÓû§¡£½«¹Ì¶¨·þÎñÆ÷½ÇÉ«   sysadmin   µÄÈκγÉÔ±¶¼Ó³É䵽ÿ¸öÊý¾Ý¿âÄÚ³ÆΪ   dbo   µÄÒ»¸öÌØÊâÓû§ÉÏ¡£ÁíÍ⣬Óɹ̶¨·þÎñÆ÷½ÇÉ«   sysadmin   µÄÈκγÉÔ±´´½¨µÄÈκζÔÏó¶¼×Ô¶¯ÊôÓÚ   ......

InfoPath¿ª·¢£º»ñÈ¡SQL ServerÖеÄÊý¾Ý

¡¡¡¡±¾ÎÄʾÀýÔ´´úÂë»òËزÄÏÂÔØ
¡¡¡¡±¾½ÚµÄÄÚÈÝ£º
¡¡¡¡ÈçºÎÔÚInfoPathÖÐʹÓÃÊý¾ÝÁ¬½ÓÀ´´ÓSQL ServerÊý¾Ý¿âÖлñÈ¡Êý¾Ý
¡¡¡¡ÈçºÎͨ¹ý´úÂëÀ´ÐÞ¸ÄÊý¾ÝÁ¬½ÓÖеÄSQL²éѯ
¡¡¡¡ÔÚ¿ªÊ¼Éè¼ÆInfoPath±íµ¥Ö®Ç°£¬ÏÈ×¼±¸Ò»¸öÊý¾Ý¿â£¬InfoPathÖ§³ÖÁ½ÖÖÊý¾Ý¿âÁ¬½Ó£º
¡¡¡¡Microsoft Office AccessÊý¾Ý¿â£¨.mdbÎļþ»ò.accdbÎļþ£©
¡¡¡ ......

SQL´´½¨Êý¾Ý¿â¡¢±í¡¢´æ´¢¹ý³Ì¼°µ÷ÓÃ

--Èç¹û´æÔÚÊý¾Ý¿â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',
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ