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

ÇósqlÓï¾ä£¡

http://www.szwtvs.com/wawa/
ÀñÎïËÑË÷
¶àÌõ¼þ²éѯÓï¾ä£¡
sf

¸øÊý¾Ý°¡..

.

ÒýÓÃ
http://www.szwtvs.com/wawa/
ÀñÎïËÑË÷
¶àÌõ¼þ²éѯÓï¾ä£¡

where... adn...

µ¹£¬Õâ¸öÈ˸üÀ÷º¦¡£Ö±½Ó¸øÐ§¹ûÒªSQLÓï¾ä¡£Á¬±í½á¹¹¶¼Ã»¡£Ôõôд£¿
˼·¾ÍÊÇ×éºÏÌõ¼þÁË¡£

ÒýÓÃ
ÒýÓÃÂ¥Ö÷ yao970953039 µÄ»Ø¸´:
http://www.szwtvs.com/wawa/
ÀñÎïËÑË÷
¶àÌõ¼þ²éѯÓï¾ä£¡

where... and...

.

ÎÒ²Ù

ÒýÓÃ
ÎÒ²Ù

ºÎ±ØÂîÈËÄØ µ­¶¨

ÒýÓÃ
¸øÊý¾Ý°¡..

SQL code:

create table Present
(
Present_Id varchar(50) not null primary key,--ÀñÆ·±àºÅ
Present_Name varchar(100) not null,--ÀñÆ·Ãû³Æ
Present_Img varchar(100) not null,--ÀñƷͼƬ
Present_Introduce varchar(200) not null,--ÀñÆ·¼ò½é
Present_wawaPrice float not null,--ÀñÆ·ÍÛÍÛ¼Û
Present_Market_Price float not null,--ÀñÆ·Êг¡¼Û
Present_Point float not null,--ÀñÆ·ÔùËÍ»ý·Ö
Present_Friendship text not null,--ËÍÀñÇéÒê
Present_Introduction text not null,--ÀñÆ·½éÉÜ
clicks int not null default(0),--µã»÷ÊýĬÈÏΪ0
addTime varchar(50) not null default(getdate()


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚc ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±í
id bh  
1 10
2 11
3 12 
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:


declare @t tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ