Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖеÄinsertÓï¾ä

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

asp.net ÖÆ×÷°²×°°ü²¢×Ô¶¯°²×°SQLÊý¾Ý¿â

Ò»).´´½¨²¿ÊðÏîÄ¿    
  1.   ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£    
  2.   ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñ ......

SQL 2005 ´´½¨Ô¼Êø

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

MS SQL Êý¾ÝÀàÐÍ

 
1
bigint     
´Ó -2^63 µ½ 2^63-1 Ö®¼äµÄ integer (ÕûÊý)Êý¾Ý
2
binary       
¶¨³¤µÄbinaryÊý¾Ý£¬×Ϊ8,000×Ö½Ú
3
bit        
integerÊý¾Ý£¬ÖµÎª1»ò0
4
char      ......

sql server2005²éѯÓÅ»¯½¨Òé


²éѯÓÅ»¯µÄÄ¿µÄÊÇÌá¸ßÊý¾Ý¼ìË÷ËÙ¶È£¬Ìá¸ßÊý¾Ý¼ìË÷Òâζ׿õÉÙ´ÅÅÌ
IO
¶ÁÈ¡»òÕßÂß¼­ÄÚ´æ¶ÁÈ¡´ÎÊý£¬ÕâÐèÒª´ÓÁ½¸ö·½ÃæÈëÊÖ£ºÊý¾ÝÒª¾¡¿ÉÄܵĻº´æµ½ÄÚ´æ¡¢¾¡¿ÉÄܵÄʹÓÃË÷Òý¡£ÄÚ´æµÄÎÊÌâ¿ÉÒԲμû
 
:
http://msdn.microsoft.com/zh-cn/library/ms188284.aspx
£¬±¾ÎÄÖ÷ÒªÊÇÌåÏÖÈçºÎʹÓÃË÷ÒýÀ´Ìá¸ßËÙ¶È¡£¾ßÌå·½·¨£º
1) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ