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

°²×°SQL Server 2000ʱÈýÖÖ³£¼û³ö´íÐÅÏ¢¼°½â¾ö·½·¨

Çé¿ö£ºÎÒÒÔǰ°²×°¹ýSQL Server 2000£¬Å¶£¬»¹ÓÐSQL Server 2005¡¢MySQLÄØ£¬ºóÀ´ÏµÍ³ÖØ×°ÁË£¬²»¹ýÕâЩӦÓóÌÐò¶¼ÔÚEÅÌÀ²»ÔÚϵͳÅÌÀ¾ÍÔÚ°²×°µÄʱºò³öÏÖÈçÏÂÈý¸ö´íÎó£¬ÔÚ´ËÖð¸ö½â¾ö˵Ã÷ÈçÏ£º
ÎÊÌâÒ»£º
±¨´íÐÅÏ¢£ºÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£
½â¾ö·½°¸£ºÔËÐÐregedit´ò¿ª×¢²á±í£¬ÕÒµ½ÈçϵÄÏHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperationsÏîÄ¿£¬¼Çס£¬ÊÇÓÃÊó±êµã»÷Session ManagerÏȻºóÓұ߾ͿÉÒÔ¿´µ½ÓÐÒ»¸öPendingFileRenameOperationsÏîÁË£¬È»ºóÓÒ»÷Êó±êɾ³ýËü¡£
ÎÊÌâ¶þ£º
±¨´íÐÅÏ¢£ºCommand line opeion syntax error, Type Command /? for Help.
½â¾ö·½°¸£º¾­²éMicrosoftµÄ°ïÖúÎĵµ£¬ÖªµÀÕâÊÇÒòΪSQL Server 2000µÄ°²×°Ä¿Â¼ÊÇÔÚÒ»¸öÓÐ×ÅÖÐÎÄÃûµÄÎļþĿ¼Ï£¬ËùÒÔ»á³öÏÖÕâÖÖÃüÁî²»ÕýÈ·µÄÌáʾ£¬½â¾ö·½·¨¾ÍÊǰÑÕâ¸öÎļþÖØÃüÃû³ÉÒ»¸ö´¿Ó¢ÎĵÄÃû×Ö£¬²»Òª´øÖÐÎÄ¡£
ÎÊÌâÈý£º
±¨´íÐÅÏ¢£º°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\WINDOWS\sqlstp.logÁ˽â¸ü¶àÐÅÏ¢¡£
½â¾ö·½°¸£º¼ÈÈ»ÌáʾÎÒÁ˽âC:\WINDOWS\sqlstp.logÀïµÄÐÅÏ¢£¬ÄÇÎÒ¾ÍÈ¥Á˽âÁË£¬Ò»¿´£¬ÄÇlogÎļþµÄ×îºóÊÇÓйØsaµÇ¼³ö´íµÄÐÅÏ¢£¬ºÇºÇ£¬ÎÒ°²×°µÄʱºòÊÇÓÃÁËsaµÄµÇ¼Ãû£¬ÃÜÂëÒ²ÊÇsa¹À¼Æ²»ÐÐÁË£¬ºÃ£¬°²×°µÄʱºòµÇ¼·½Ê½£¬¸Ä³ÉWindowϵǼ¾ÍOKÁË¡£
°¦£¬°²×°Èý´Î²Å³É¹¦£¬É¹É¹ÕâЩСʰɣ¬²»ÖªµÀÄܲ»ÄܰïÆäËûÈËͬÑùµÄ´íÎó¡£


Ïà¹ØÎĵµ£º

SQL SERVER 2000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨

ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......

½«Êý¾Ý¿â±íÖеÄÊý¾ÝתΪsqlÖеÄinsertÓï¾ä

 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì ......

powerdesignerÉú³ÉsqlÈ¥µôË«ÒýºÅ

ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â
½¨±íSQL
½Å
±¾Ê±£¬ÓÈÆäÊÇOracleÊý¾Ý¿âʱ£¬±íÃûÒ»°ã»á´øÒýºÅ¡£Æäʵ¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕ
ORACLEĬÈϵÄÉèÖý¨±í£¨DBA
STUDIOÀïÃæ£©£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1&rdqu ......

SQL 2005 ´´½¨Ô¼Êø

²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
 
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
 
1.       CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼­±í´ïʽÀ´ÅжÏÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ