ÐÞ¸Ä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
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£ ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£ ¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......
×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£ È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´ ·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬?? ÓÃsaµÇ½ҲÊÇ... ºÜÆæ¹Ö°¡.. ´óÅ£ÖªµÀÊÇʲôÔÒòÂð? Ô¸Òâ³ö¸ß·ÖÇó ˽â¾öÁË ¸ø200·Ö!! Êý¾Ý¿â³öÎÊÌâÁË? ÒýÓà ×î½üÏÂÃæ ......
ÒѾ¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£ ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......
ÏÖÏóÈçÏ£ºÖØÆôÒ»Êý¾Ý¿â·þÎñÆ÷£¨windows2003+MSSQL2000£©ºó£¬ÆäÖÐÒ»Êý¾Ý¿âÁ¬½Ó²»ÉÏ¡£´ËʱÆäËüÊý¾Ý¿âÔËÐÐÕý³£¡£ÎÒʹÓÃMSSQL2008Ô¶³ÌÁ¬ÉÏÊý¾Ý¿â£¬É¾³ý´ËÊý¾Ý¿âºó£¬Ê¹Óø½¼ÓÊý¾Ý¿âÖØÐÂÌí¼ÓÉÏЩÊý¾Ý¿âºó¾ÍÄÜÕý³£Ê¹Óá£´Ë ......
ÎÒÏëÔÚJspÒ³ÃæÀïÃæ»Ö¸´Êý¾Ý¿â£¬²Î¿¼ÁËһЩ×ö·¨£¬Óô洢¹ý³Ì¶Ï¿ªÊý¾Ý¿âµÄÁ´½Ó¡£ /* ¹Ø±ÕÓû§´ò¿ªµÄ½ø³Ì´¦Àí */ use master go create&nb ......