ÀûÓÃSQLSERVERµÄʼþ̽²âÆ÷ÕÆÎÕÓÃÓÑϵͳµÄ±í½á¹¹
	
    
    
	SQLSERVERµÄʼþ̽²âÆ÷ÊÇÒ»¸öºÜÇ¿´óºÜÖ±¹ÛµÄ¹¤¾ß£¬µ±ÎÒÃÇÔÚERPϵͳÀïÃæ×öÒ»¶¨²Ù×÷µÄʱºò£¬¶¼»áÔÚÊý¾Ý¿âÀïÃæÐγɲéѯ»òÕßÔöɾ¸ÄµÄT-SQLÓï¾ä¡£Í¨¹ýʼþ̽²âÆ÷¾Í¿ÉÒÔÖªµÀERPÀïÃæµÄµ¥¾ÝÔÚÊý¾Ý¿âµÄÄĸö±íÀïÃæ£¬ÉõÖÁÄĸö×Ö¶ÎÀïÃæ¡£»¹¿ÉÒÔ¸ù¾Ý̽²âµ½µÄSQLÓï¾ä·ÖÎöERPϵͳµÄ±í½á¹¹£¬±íÖ®¼äµÄ¹ØÁª×Ö¶ÎÊÇÄĸö¡£
´ó¼Ò³õ´ò¿ªÊ¼þ̽²âÆ÷ʱ¿ÉÄÜ»á¸ã²»´óÇå³þ£¬ÒòΪERPÔÚÔËÐÐʱ£¬ºǫ́µÄSQLÓï¾äÁ¿ÊǺܴóµÄ£¬1ÃëÖÓ¿ÉÒÔÌø¸ö¼¸Ê®Ìõ£¬Äã¸ù±¾²»ÖªµÀÄľäSQLÊÇÕë¶ÔÄãµÄ²Ù×÷µÄ¡£
ÕâÀï¾Í¸ú´ó¼Ò·ÖÏí1Ï£¬1¸öºÜºÃµÄ·½·¨¾ÍÊÇÔÚ´ò¿ªÊ¼þ̽²âÆ÷ʱ£¬ÔÚÄ£°åÉèÖýçÃæµÄµÚÈý¸öÑ¡ÏÀïÃæ°Ñ"hostname"¸øÑ¡ÉÏ£¬È»ºóÔÚµÚËĸöÑ¡Ï£¨Êý¾ÝÁУ©ÀïÃæÕÒµ½hostname£¬´ò¿ªÄ¿Â¼Ê÷£¬ÉèÖÓͬÓÚ¡¾ÄãµÄ¼ÆËã»úÃû×Ö¡¿”£¬µãÈ·¶¨¡£ÕâÑùʼþ̽²âÆ÷¾ÍÖ»¸ú×ÙÄãµçÄÔÉϵÄERPÔÚÊý¾Ý¿â×öµÄ²Ù×÷¼Ç¼¡£
Äã¿ÉÒÔ°ÑÓÐÓõÄSQLÓï¾ä¸´ÖƵ½²éѯ·ÖÎöÆ÷ÀïÃæ£¬È»ºóselect top 1 * from Ö»ÏÔʾ1ÐУ¬»á³öÀ´Êý¾Ý¡£Õâ¸öÊý¾Ý¸úǰ̨ERPÀïÃæµÄÊý¾ÝÈ¥ºË¶Ô£¬Äã¾ÍÖªµÀÕâ¾äSQLÔÚ¸ÉÂËûµÄÿ¸ö×ֶδú±íʲôÒâ˼¡£
ÓÃÓÑ×öÁ˺ܶàµÄÊÓͼ£¬¶ÔÓÚÎÒÃÇ×ö×Ô¶¨Ò屨±íÈ¡Êý¾Ý»áºÜ·½±ã¡£µ«ÊÇÕâЩÊÓͼµÄ×ÊÁÏÍøÉÏ»ù±¾ÕÒ²»µ½£¬ËùÒÔÀûÓÃʼþ̽²âÆ÷¿ÉÒÔ½Ó´¥µ½ÕâЩÊÓͼ¡£
ÁíÍâÓÃÓÑÿ¾äSQL¶¼»á´ø1¾äset nocount on ÆäʵÕâ¾ä»°Ã»Ê²Ã´Òâ˼£¬¾ÍÊÇÈÃSQLSERVER²»¸øERP·µ»Ø´Ë´Î²Ù×÷Ó°ÏìµÄÐÐÊý£¬ÕâÑù¿ÉÒÔ½ÚÊ¡Á÷Á¿¡£
ÏȽéÉܵ½ÕâÀÀûÓÃÕâ¸ö·½·¨¿ÉÒÔ½â¾öºÜ¶àºÜ¶àÎÊÌ⣬»òÕß˵¿ÉÒÔÌṩºÜ¶à½â¾öÎÊÌâµÄ˼·¡£
µ±È»ÁË£¬ÐÞ¸ÄÊý¾Ý¿âÊý¾Ý֮ǰ¶¼Òª±¸·ÝÊý¾Ý¿â¡£
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS   ·µ»Ø
 SQL Server 
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS   
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST        
Õë¶Ô»á»°·µ»Ø
 S ......
	
    
        
    
    ÒÔ³¬¼¶¹ÜÀíÔ±µÇ¼ϵͳ£¬È»ºóÖ´ÐÐÒÔϽű¾¾Í¿ÉÒÔÅúÁ¿Ð޸ĶÔÏóËùÓÐÕß¡£
sp_configure 'allow updates','1' 
go 
reconfigure with override 
go 
update sysobjects set uid=1 where uid<>1 
go 
sp_configure 'allow updates','0' 
go 
reconfigure with override  ......
	
    
        
    
    ÏÂÃæÊÇÎÒÔÚSQLServerÖÐÓõıȽ϶àµÄº¯Êý£¬Ä㻹ÓÃЩʲôº¯Êý£¿»òÕß¶ÔÄĸöº¯ÊýÓбȽϺÃÓ÷¨£¿»òÕßÄã²»ÓÃÄÄЩº¯Êý£¿
LEFT ( character_expression , integer_expression ) 
·µ»Ø´Ó×Ö·û´®×ó±ß¿ªÊ¼Ö¸¶¨¸öÊýµÄ×Ö·û¡£
Àý:
select left('my name is viwo',4)
my n
RIGHT ( character_expression , integer_expression ) 
·µ» ......
	
    
        
    
         ÀýÈç´´½¨Ò»¸ö±í
                 create table stz
              (
          &n ......