°²×°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 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì
......
ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â
½¨±íSQL
½Å
±¾Ê±£¬ÓÈÆäÊÇOracleÊý¾Ý¿âʱ£¬±íÃûÒ»°ã»á´øÒýºÅ¡£Æäʵ¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕ
ORACLEĬÈϵÄÉèÖý¨±í£¨DBA
STUDIOÀïÃæ£©£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1&rdqu ......
²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
1. CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼±í´ïʽÀ´ÅжÏÊý¾ ......