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

Óà SqlÌí¼Óɾ³ý×ֶΣ¬ÅжÏ×Ö¶ÎÊÇ·ñ´æÔڵķ½·¨

http://www.cnblogs.com/dwjaissk/archive/2006/07/25/459476.aspx
Ôö¼Ó×Ö¶Î
alter table docdsp  add dspcode char(200)
ɾ³ý×Ö¶Î
ALTER TABLE
table_NAME DROP COLUMN column_NAME
ÐÞ¸Ä×Ö¶ÎÀàÐÍ
ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type
¸ÄÃû
sp_rename
¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§
´´½¨¶ÔÏó£¨Èç±í¡¢ÁлòÓû§¶¨ÒåÊý¾ÝÀàÐÍ£©µÄÃû³Æ¡£
Óï·¨
sp_rename [ @objname = ] 'object_name' ,
    [ @newname = ]
'new_name'
    [ , [ @objtype = ] 'object_type' ]
--¼ÙÉèÒª´¦ÀíµÄ±íÃûΪ: tb
--ÅжÏÒªÌí¼ÓÁеıíÖÐÊÇ·ñÓÐÖ÷¼ü
if exists(select 1 from sysobjects where
parent_obj=object_id('tb') and xtype='PK')
begin
 print
'±íÖÐÒѾ­ÓÐÖ÷¼ü,ÁÐÖ»ÄÜ×öΪÆÕͨÁÐÌí¼Ó'
 --Ìí¼ÓintÀàÐ͵ÄÁÐ,ĬÈÏֵΪ0
 alter table tb add ÁÐÃû int default 0 
end
else
begin
 print
'±íÖÐÎÞÖ÷¼ü,Ìí¼ÓÖ÷¼üÁÐ'
 --Ìí¼ÓintÀàÐ͵ÄÁÐ,ĬÈÏֵΪ0
 alter table tb add ÁÐÃû int primary key default

end
/**************************************************************************************/
ÅÐ
¶Ïtable1ÖÐÊÇ·ñ´æÔÚname×Ö¶Î
if exists(select * from syscolumns where
id=object_id('table1') and name='name') begin
select * from people;
end


Ïà¹ØÎĵµ£º

SQL Server¹ÊÕÏÐÞ¸´¼¼ÇÉ

SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔ­ÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã±ØÐë¼ÇסµÄÊǽ«±¸Ó÷þÎñÆ÷Ìæ»»ÉÏÏßÖ»ÊÇÍê³ÉÁËÒ»°ëµÄ¹ÊÕÏÐÞ¸´¹¤×÷¡£
Òª±£Ö¤ÄãµÄÓ¦ÓÃÕý³£¹¤×÷£¬ÔÚÊý¾Ý¿â ......

sql server ´´½¨±íʱΪÁÐÌí¼Ó˵Ã÷


IF NOT EXISTS (SELECT * from ::fn_listextendedproperty
(N'MS_Description' , N'SCHEMA',N'dbo',
N'TABLE',N'±íÃû', N'COLUMN',N'ÁÐÃû'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description',
@value=N'˵Ã÷ÄÚÈÝ' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE',@level1name=N'±íà ......

SQL Server 2008 ¸½¼ÓÊý¾Ý¿âʧ°ÜµÄ½â¾ö°ì·¨

×òÌìÔÚ½«Ò»¸ö SQL Server 2000 Êý¾Ý¿â¸½¼Óµ½ SQL Server 2008 ʱ³öÏÖÈçϵĴíÎó£º
¸½¼ÓÊý¾Ý¿â ¶ÔÓÚ ·þÎñÆ÷“servername”ʧ°Ü¡£  (Microsoft.SqlServer.Smo)
ÎÞ·¨Éý¼¶Êý¾Ý¿â ‘dbname’£¬ÒòΪËüÊÇÖ»¶ÁµÄ£¬»òÕß¾ßÓÐÖ»¶ÁÎļþ¡£Ç뽫Êý¾Ý¿â»òÎļþÉèΪ¿Éд£¬È»ºóÖØÐÂÔËÐлָ´²Ù×÷¡£ (Microsoft SQL S ......

SQLÓï¾ä¹Ø¼ü×ÖUNIONС֪ʶ

   ½ñÌìÔÚÓÃUNION½øÐн«Á½¸ö²éѯ½áºÏʱ£¬·¢ÏÖ¼ÓÁËtextÀàÐ͵Ä×ֶνøÈ¥¾Í±¨´íÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
²»ÄÜÒÔ DISTINCT ·½Ê½Ñ¡Ôñ text¡¢ntext »ò image Êý¾ÝÀàÐÍ¡£
     ¾­¹ý·­ÔÄ×ÊÁϺó²ÅÖªµÀ£¬Ô­ÒòÔÚÓÚÈç´Ë²Ù×÷ ÎÞ·¨¶ÔtextÀàÐÍÅжÏÊÇ·ñÖظ´£¬ËùÒÔÒªÔÚUNIONºó¼Ó¸öALL¹Ø¼ü×Ö£¬ÈçÏ£º
select top ......

SQL´¥·¢Æ÷ʵÀý

SQL´¥·¢Æ÷ʵÀý1
¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
      ³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete ʼþ¡£
      ÎÒΪʲôҪʹÓô¥·¢Æ÷£¿±ÈÈ磬 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ