Óà 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
0
end
/**************************************************************************************/
ÅÐ
¶Ïtable1ÖÐÊÇ·ñ´æÔÚname×Ö¶Î
if exists(select * from syscolumns where
id=object_id('table1') and name='name') begin
select * from people;
end
Ïà¹ØÎĵµ£º
SQL Server 2005 ºÍ 2008 Óм¸¸ö¹ØÓڸ߿ÉÓÃÐÔµÄÑ¡ÏÈçÈÕÖ¾´«Êä¡¢¸±±¾ºÍÊý¾Ý¿â¾µÏñ¡£ËùÓÐÕâЩ¼¼Êõ¶¼Äܹ»×÷Ϊά»¤Ò»¸ö±¸Ó÷þÎñÆ÷µÄÊֶΣ¬Í¬Ê±Õâ¸öÊý¾Ý¿â¿ÉÒÔÔÚÄãÔÏȵÄÖ÷Êý¾Ý¿â³öÎÊÌâʱÉÏÏß²¢×÷ΪеÄÖ÷·þÎñÆ÷¡£È»¶ø£¬Äã±ØÐë¼ÇסµÄÊǽ«±¸Ó÷þÎñÆ÷Ìæ»»ÉÏÏßÖ»ÊÇÍê³ÉÁËÒ»°ëµÄ¹ÊÕÏÐÞ¸´¹¤×÷¡£
Òª±£Ö¤ÄãµÄÓ¦ÓÃÕý³£¹¤×÷£¬ÔÚÊý¾Ý¿â ......
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 2000 Êý¾Ý¿â¸½¼Óµ½ SQL Server 2008 ʱ³öÏÖÈçϵĴíÎó£º
¸½¼ÓÊý¾Ý¿â ¶ÔÓÚ ·þÎñÆ÷“servername”ʧ°Ü¡£ (Microsoft.SqlServer.Smo)
ÎÞ·¨Éý¼¶Êý¾Ý¿â ‘dbname’£¬ÒòΪËüÊÇÖ»¶ÁµÄ£¬»òÕß¾ßÓÐÖ»¶ÁÎļþ¡£Ç뽫Êý¾Ý¿â»òÎļþÉèΪ¿Éд£¬È»ºóÖØÐÂÔËÐлָ´²Ù×÷¡£ (Microsoft SQL S ......
½ñÌìÔÚÓÃUNION½øÐн«Á½¸ö²éѯ½áºÏʱ£¬·¢ÏÖ¼ÓÁËtextÀàÐ͵Ä×ֶνøÈ¥¾Í±¨´íÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
²»ÄÜÒÔ DISTINCT ·½Ê½Ñ¡Ôñ text¡¢ntext »ò image Êý¾ÝÀàÐÍ¡£
¾¹ý·ÔÄ×ÊÁϺó²ÅÖªµÀ£¬ÔÒòÔÚÓÚÈç´Ë²Ù×÷ ÎÞ·¨¶ÔtextÀàÐÍÅжÏÊÇ·ñÖظ´£¬ËùÒÔÒªÔÚUNIONºó¼Ó¸öALL¹Ø¼ü×Ö£¬ÈçÏ£º
select top ......
SQL´¥·¢Æ÷ʵÀý1
¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete ʼþ¡£
ÎÒΪʲôҪʹÓô¥·¢Æ÷£¿±ÈÈ磬 ......