SQL ServerÖеÄÔ¼ÊøÌõ¼þ
1.ĬÈÏÔ¼Êø£º¶¨Òå¸ÃÁÐδÊäÈëֵʱӦ¸Ã¾ßÓеÄĬÈÏÖµ
SQL-------alter table ±íÃû add constraint dt_ÁÐÃû default ĬÈÏÖµ for ÁÐÃû
2.¿ÕÖµÔ¼Êø£º¶¨Òå¸ÃÁÐÊÇ·ñÔÊÐíΪ¿ÕÖµ
SQL-------¶¨Òå±íµÄʱºòÔÚ¶ÔÓ¦ÁÐÁÐÊý¾ÝÀàÐͺóÃæÌí¼Ónot null
3.¼ì²éÔ¼Êø£ºÓÖ½ÐcheckÔ¼Êø£¬ÓÃÀ´ÏÞÖÆÁеÄÈ¡Öµ£¬Ëü¸ù¾Ý¶¨ÒåµÄÂß¼±í´ïʽÀ´Ç¿ÖÆÓòµÄÍêÕûÐÔ
SQL-------alter table ±íÃû add constraint ck_ÁÐÃû check(Âß¼±í´ïʽ)
4.ΨһԼÊø£ºÈ·±£ÔÚ·ÇÖ÷¼üÁв»ÊäÈëÖظ´Öµ
SQL-------alter table ±íÃû add constraint uq_ÁÐÃû unique[clustered | nonclustered](ÁÐÃû)
5.Íâ¼üÔ¼Êø£ºÓÃÓÚ½¨Á¢Á½¸ö±íÊý¾ÝÖ®¼äÁ¬½ÓµÄÒ»Áлò¶àÁÐ
SQL-------alter table ±íÃû add constraint fk_ÁÐÃû foreign key(ÁÐÃû) references ÁíÒ»±íÃû(ÁÐÃû)
6.Ö÷¼üÔ¼Êø£ºÓÃÀ´Î©Ò»µØ±êʶ±íÖеÄÿһÐÐ
SQL-------alter table ±íÃû add constraint pk_ÁÐÃû primary key(ÁÐÃû)
ÐÂÔöÁУºalter table ±íÃû add ÐÂÁÐÃû Êý¾ÝÀàÐÍ
ɾ³ýÁУºalter table ±íÃû drop column ÁÐÃû
ɾ³ýÔ¼Êø£ºalter table ±íÃû drop constraint Ô¼ÊøÃû
ÐÞ¸ÄÁÐÊý¾ÝÀàÐÍ£ºalter table ±íÃû alter column ÁÐÃû ÐÂÊý¾ÝÀàÐÍ
ÐÞ¸ÄÁÐÃûÐèÒªµ÷Óô洢¹ý³Ìsp_rename
Ïà¹ØÎĵµ£º
sql²éѯÖÐÏÔʾÐòºÅ
2009-06-04 09:27
/* ·½·¨Ò»*/
SELECTÐòºÅ= (SELECT COUNT(¿Í»§±àºÅ) from ¿Í»§ AS LiMing
WHERE LiMing.¿Í»§±àºÅ<= Chang.¿Í»§±àºÅ),
¿Í»§±àºÅ,¹«Ë¾Ãû³Æ
from¿Í»§ AS Chang ORDER BY 1;
G ......
1: /*
2: ͨ¹ýSQL Óï¾ä±¸·ÝÊý¾Ý¿â
3: */
4: BACKUP DATABASE mydb
5: TO DISK ='C:\DBBACK\mydb.BAK'
6: --ÕâÀïÖ¸¶¨ÐèÒª±¸·ÝÊý¾Ý¿âµÄ·¾¶ºÍÎļþÃû,×¢Òâ:·¾¶µÄÎļþ¼ÐÊDZØÐëÒѾ´´½¨µÄ.ÎļþÃû¿ÉÒÔʹÓÃÈÕÆÚÀ´±êʾ
7:
8: /*
9: ͨ¹ýSQLÓï¾ä»¹ÔÊý¾Ý¿â
10: */
11: USE ma ......
¸üÐÂÏÂÎÊÌ⣺
񡜧TBL_Info
×ֶΣº
infoId int
title varchar(20)
Content text
byUser varchar(20)
createTime datetime
1¡¢ÈçºÎɾ³ý±íÖÐÊý¾ÝÏàͬµÄÊý¾ÝÄØ£¿£¨Ö÷¼ü³ýÍ⣩
2¡¢ÈçºÎɾ³ýÊý¾Ý±íÖÐij¸ö×Ö¶ÎÊý¾ÝÏàÍ ......
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æ룬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊ ......
ÒÔstring ÀàÐ͵ÄNameΪÀý
ÔÚSQL Óï¾äÀ string sql="Name like'%" + Name.Text + "%';
ÔÚ´æ´¢¹ý³ÌÀ
if @Name!=''
begin
set @strWhere= +' and Name like '''+'%'+@Name+'%'+''''
end
´æ´¢¹ý³ÌÖеÄÒýºÅÊǵ¥ÒýºÅ.
like '''+'%'Öм䲻ÓÃ+Èϲ» ......