ÐÞ¸ÄmssqlÁеÄÃû³Æ 
    
	
	ÎÒÒª°Ñv10004¸Ä³ÉÃû×ÖÆøÑ¹£¬ÎªºÎ×ܳö´í   EXEC   sp_rename   'dbo,A0131.[v10004]',   'ÆøÑ¹',   'COLUMN'      ÏûÏ¢ 15248£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_rename£¬µÚ 213 ÐÐ   ²ÎÊý @objname ²»Ã÷È·»òËùÉùÃ÷µÄ @objtype (column)ÓÐÎó¡£   
 SQL code:  EXEC sp_rename '[A0131].[v10004]', 'ÆøÑ¹', 'column'  ÐÖµÜ Äã¸úÎÒдµÄÒ»Ñù ʲôÒâ˼ÄãÊÇÒýÓà  ÐÖµÜ Äã¸úÎÒдµÄÒ»Ñù ʲôÒâ˼ÄãÊÇ       ÄãÓÐÊÔ¹ýÎÒдµÄÓï¾äÂ𣿠SQL code:  EXEC sp_rename Êý¾Ý¿â.±í.¾ÉÁÐÃû, ÐÂÁÐÃû, 'COLUMN';ÒýÓà  ÐÖµÜ Äã¸úÎÒдµÄÒ»Ñù ʲôÒâ˼ÄãÊÇ    ÐǪ̈£¬È˼ÒÉîÒ¹»Ø´ðÄãÎÊÌ⣬ÄãÒ²¾ÍÕâÑù̬¶È¡£°¥¡£¡£¡£¡£¡£±¾ß¡¢²è¾ß ÊÔ¹ýÁ˰¡¡£¡£¡£Ð§¹û¸úÎÒ֮ǰµÄÒ»ÑùµÄ¡£¡£¡£¡£   ÒýÓà  SQL codeEXEC sp_rename'[A0131].[v10004]','ÆøÑ¹','column' SQL code:  --> ²âÊÔÊý¾Ý£º[ta] if object_id('[ta]') is not null drop table [ta] create table [ta](id int primary key) insert [ta] select 3 union all select 5 union all select 6 union all select 9 select * fro
    
 
	Ïà¹ØÎÊ´ð£º
        
    
    ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......
    
        
    
    ÒѾ¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£ ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......
    
        
    
    ÎÒÔÚMSSQL¹ÜÀíÆ÷Àï°Ñн¨×Ö¶Îstr      ÔÚĬÈÏÖµ»ò°ó¶¨ÄÇÀïÎÒÌîдÁË0       È»ºóÎÒ·¢ÏÖ¡£Èç¹ûÎÒÔÚÔö¼Ó¼Ç¼ʱ¡£Õâ¸öSTR²¢²»ÊÇĬÈϵÄ0¶øÊÇNULLÔõô»ØÊ£¿£¨ÔÚÔö¼Ó×Ö¶Îʱ¡£ÎÒûÓмÈërs("str")µÄÖµ¡£Ô±¾Ò ......
    
        
    
    mssql 2005 ÊÇÓ¢ÓïÕý°æµÄ¡£   ²»ÖªµÀΪʲôÀýÈç   select content_cn,content_ru  from table where content_cn like '%ÖÐÎÄ%'   select content_cn,content_ru  from table where content_ru  ......
    
        
    
    ÎÒÔÀ´ÊÇÓÉaccessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË  ÎÒÔõôÓÃsqlÀ´×ª»¯ÄØ£¿£¨²»ÏëÔÚÆóÒµÃæ°å¹ÜÀíÖÐ¸Ä ±íÌ«¶à..£© »¹ÓÐsmalldateµÄĬÈÏÖµ¸Ä³Égetdate()µÄÓï¾äÒªÔõôд..ллÁË accessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶ ......