Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÐÞ¸Ä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


Ïà¹ØÎÊ´ð£º

vc²Ù×÷mssqlһСÎÊÌâ

ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......

mssqlºÃ¶à±í¶¼"Ö»¶Á"

×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôԭÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
Ë­½â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?

ÒýÓÃ
×î½üÏÂÃæ ......

ÈçºÎÓÃasp²åÈëÊýÖµµ½ mssql Varbinary(16)×Ö¶Î

ÒѾ­¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£
ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......

ÖØÆô·þÎñÆ÷£¬MSSQLÖÐijһÊý¾Ý¿âËÀ

ÏÖÏóÈçÏ£ºÖØÆôÒ»Êý¾Ý¿â·þÎñÆ÷£¨windows2003+MSSQL2000£©ºó£¬ÆäÖÐÒ»Êý¾Ý¿âÁ¬½Ó²»ÉÏ¡£´ËʱÆäËüÊý¾Ý¿âÔËÐÐÕý³£¡£ÎÒʹÓÃMSSQL2008Ô¶³ÌÁ¬ÉÏÊý¾Ý¿â£¬É¾³ý´ËÊý¾Ý¿âºó£¬Ê¹Óø½¼ÓÊý¾Ý¿âÖØÐÂÌí¼ÓÉÏЩÊý¾Ý¿âºó¾ÍÄÜÕý³£Ê¹Óá£´Ë ......

mssqlÊý¾Ý¿â»Ö¸´ÎÊÌ⣬¼±

ÎÒÏëÔÚJspÒ³ÃæÀïÃæ»Ö¸´Êý¾Ý¿â£¬²Î¿¼ÁËһЩ×ö·¨£¬Óô洢¹ý³Ì¶Ï¿ªÊý¾Ý¿âµÄÁ´½Ó¡£

/* 
  ¹Ø±ÕÓû§´ò¿ªµÄ½ø³Ì´¦Àí 
  */
  use master
go
    create&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ