¹ØÓÚMSSQLÐ޸ļÆËãÁÐ
sql2005 Äܲ»Äܶ¯Ì¬Ð޸ļÆËãÁеĶ¨ÒåÁË°¡
ÏÖÔÚºÜÓôÃƵÄÊÇ
Èç¹ûÓÃÏÈɾ³ý ÔÙÌí¼Ó¼ÆËãÁеĻ°
ÓëÆäÏà¹ØµÄÊÓͼ ÓÖÒªÖØаÑ×Ö¶ÎÑ¡ÉÏ
ALTER TABLE TabelName ADD ColumnC AS ColumnA+ColumnB
ÏÖÔÚÏ뽫Æ䶨Òå¸ÄΪColumnA*ColumnB,ÐÞ¸ÄÁж¨ÒåµÄÓï¾äÈçºÎд£¿Ð»Ð»ÁË
±ØÐëÒªÏÈɾ³ý ÔÙÌí¼Ó°É
Àá±¼ÁË Èç¹ûÕâÑù ÎÒ»¹ÊÇ
ÊÔ×Å ÓöÔÏó¹ÜÀíÆ÷ Ð޸ıí½á¹¹ ÐÞ¸ÄÏ¿´¿´
Êý¾ÝÌ«¶à ¸ù±¾ÎÞ·¨ÐÞ¸Ä Ò»Ð޸ľͳ¬Ê± °¥
SQL code:
alter table tb add col3 int
update tb set col3 =col1+col2
²»ÓÃɾ³ý£¬Ö±½ÓÐ޸ľͺÃÁË£¬sp_rename 'table.columnA','columnA*columnB'
Ö±½Ó±¨´í ¹À¼ÆÊDz»ÄܸļÆËãÁеÄ
¾¯¸æ: ¸ü¸Ä¶ÔÏóÃûµÄÈÎÒ»²¿·Ö¶¼¿ÉÄÜ»áÆÆ»µ½Å±¾ºÍ´æ´¢¹ý³Ì¡£
ÏûÏ¢ 4928£¬¼¶±ð 16£¬×´Ì¬ 1£¬¹ý³Ì sp_rename£¬µÚ 520 ÐÐ
ÎÞ·¨¸ü¸ÄÁÐ 'FDZ_Countprice'£¬ÒòΪËüÊÇ 'COMPUTED'¡£
-0-ѧϰÁË= =
²»ÄÜÖ±½ÓÐ޸ĵÄ
alter table test1
drop column [d]
alter table test1
add [d] as [a]+[b]
Ïà¹ØÎÊ´ð£º
Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,ËøסÖ÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀ뼶±ð
Äã²åÄãµÄ,Ëû²å ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
²»ÊÇ»¹ÓÐsybase paradox sqllite µÈµÈ
Ö»¼û¹ýwinformÓÃÕâЩºÃ¼ûµÃÊý¾Ý¿â
asp.netòËÆÖ»ÓÐÈËÓÃaccess mssql mysql
Ë˵µÄ£¬ÏÖÔÚÖ÷Á÷ÊÇmssqlºÍoracle
oracleµÄ·¹ý~
΢Èí¼ÒµÄ£¬µÁ°æµÄ~~~~~~
΢Èí×Ô¼Òµ ......