·¢²¼Ê±¼ä : ÐÇÆÚÒ» ÎÄÕÂSQL Server Êý¾Ý¿â×ܽá¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ0db6dd8b25c52cc58ad6beab
µÚÁù´óÀà:Unincode×Ö·û´®Êý¾Ý
nchar:³¤¶ÈÊÇÉ趨µÄ,×î¶ÌΪ1×Ö½Ú,×Ϊ4000¸ö×Ö½Ú.²»×ãµÄ³¤¶È»áÓÿհײ¹ÉÏ.´¢´æÒ»¸ö×Ö·ûÐèÒª2¸ö×Ö½Ú.
nvarchar:³¤¶ÈÊÇÉ趨µÄ,×î¶ÌΪ1×Ö½Ú,×Ϊ4000¸ö×Ö½Ú.β²¿µÄ¿Õ°×»áÈ¥µô.´¢´æÒ»¸ö×Ö·ûÐèÒª2¸ö×Ö½Ú.
ntext:³¤¶ÈÊÇÉ趨µÄ,×î¶ÌΪ1×Ö½Ú,×Ϊ2G.β²¿µÄ¿Õ°×»áÈ¥µô,´¢´æÒ»¸ö×Ö·ûÐèÒª2¸ö×Ö½Ú.
µÚÆß´óÀà:»õ±ÒÊý¾ÝÀàÐÍ
money:¼Ç¼½ð¶î·¶Î§Îª:-92233720368577.5808ÖÁ92233720368577.5807.ÐèÒª8 ¸ö×Ö½Ú.
smallmoney:¼Ç¼½ð¶î·¶Î§Îª:-214748.3648ÖÁ214748.36487.ÐèÒª4¸ö×Ö½Ú.
µÚ°Ë´óÀà:±ê¼ÇÊý¾Ý
timestamp:¸ÃÊý¾ÝÀàÐÍÔÚÿһ¸ö±íÖÐÊÇΨһµÄ!µ±±íÖеÄÒ»¸ö¼Ç¼¸ü¸Äʱ,¸Ã¼Ç¼µÄtimestamp×ֶλá×Ô¶¯¸üÐÂ.
uniqueidentifier:ÓÃÓÚʶ±ðÊý¾Ý¿âÀïÃæÐí¶à¸ö±íµÄΨһһ¸ö¼Ç¼.
µÚ¾Å´óÀà:¶þ½øÖÆÂë×Ö·û´®Êý¾Ý
binary:¹Ì¶¨³¤¶ÈµÄ¶þ½øÖÆÂë×Ö·û´®×Ö¶Î,×î¶ÌΪ1,×Ϊ8000. varbinary:Óëbinary²îÒìΪÊý¾Ýβ²¿ÊÇ00ʱ,varbinary»á½«ÆäÈ¥µô image:Ϊ¿É±ä³¤¶ÈµÄ¶þ½øÖÆÂë×Ö·û´®,×2G.
ÉèÖÃ×Ô¶¯Ôö³¤ÁÐ
Êý¾Ý¿âÍêÕûÐÔ
http://baike.http://china-audit.com//view/992852.htm
Ö÷¼ü
SQL×¢ÊÍ
µÚÒ»ÖÖ£ºµ¥ÐÐ --select * from Student µÚ¶þÖÖ£º¶àÐÐ /**/
»ù´¡²éѯ
²éѯËùÓУº Select * from ±íÃû
select*fromStudent
н¨²éѯ¡úÑ¡ÔñÊý¾Ý¿â¡ú±àдSQLÓï¾ä¡£
²éѯָ¶¨ÁÐ
selectname,sex,agefromStudent
Ìõ¼þ²éѯ£ºwhere×Ó¾ä
SELECT ÁÐÃû FROM ±íÃû where Ìõ¼þ
²éѯÐÔ±ðΪÄеÄËùÓмǼ
selectname,sex,agefromStudentwheresex='ÄÐ'
²éѯÄêÁä´óÓÚ25ËêµÄËùÓмǼ¡£
select*fromStudentwhereage>25
²éѯËùÓÐÈËÊýµÄÊýÁ¿(count ¾ÛºÏº¯Êý)
selectcount(*)fromStudent
·¶Î§²éѯ£º