ÐÞ¸Ä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
Ïà¹ØÎÊ´ð£º
Ö÷»ú ¿Í»§»úc1,c2,c3,c4,c5............ ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû Ö±½ÓÓÃinsert ʱ,Ëø×¡Ö÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ Çë¸ßÊÖÖ§ÕÐ.. Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀë¼¶±ð Äã²åÄãµÄ,Ëû²å ......
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿ ÈçÌâ Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É ÒýÓà ³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£ .. ÄÇÓÐûÓÐϵͳ´ ......
ÎÒ¼ÒÓõÄÊÇXP ÔÀ´ÊǸãasp access¿ª·¢ ÏÖÔÚÓÐÒ»¸öÏîĿҪmssql xpÎÒÓÖ²»ÄÜ×°sqlÆóÒµ°æ¡£ÇëÎÊÓÐûÓÐʲôÂÌÉ«»òÕߺõÄÈí¼þ½éÉÜ£¬ÄÜ´ò¿ªmssqlµÄmdf ÒýÓà ÎÒ¼ÒÓõÄÊÇXP ÔÀ´ÊǸãasp access¿ª·¢ ÏÖÔÚ ......