Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

sqlÓï¾äinµÄÓйØÎÊÌâ - MS-SQL Server / »ù´¡Àà

SQL code:

select * from product where sku in ('119-041','120-051','114-017','101-085','244-079','114-015','238-003','251-012','251-037','243-028','231-364','240-029')
²éѯ³öÀ´µÄ²úÆ·¼Ç¼ÊÇ°´ÕÕË÷Òý˳ÐòÅÅÁеģ¬¿ÉÊÇÎÒÏë²úÆ·µÄ˳Ðò°´ÕÕºóÃæµÄÀ¨ºÅÀïµÄsku˳ÐòÏÔʾ£¬²»ÖªµÀ´ó¼ÒÓÐʲô·½·¨Âð£¿

ûÓмò±ãµÄ· ......

¼òµ¥µÄSQLÎÊÌâ - .NET¼¼Êõ / ASP.NET

СµÜÔÚ×ö²éѯÆ÷µÄʱºòÓõ½
 string str = "select *from Info where 1=1 ";//1=1ΪÓÀÕæÀ´ÊµÏÖÆ´½Ó²éѯÌõ¼þÆ´½Ó¡£
µ«ÎÒÏëʵÏÖÆ´½Óºó°´Ê±¼äÅÅÐò¼´
 string str = "select *from Info where 1=1 order by Published Desc";//1=1ΪÓÀÕæ
È´³öÏÖÎÊÌâÁË£¬ÏÂÃæÊÇ´íÎóÌáʾ
Óï·¨´íÎó (²Ù ......

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

SQL code:

create table student (sid varchar(10),sname varchar(10),sage varchar(10),ssex varchar(10))
create table Sc (sid varchar(10),cid varchar(10),score int)
insert into sc select '0001','001',80
insert into sc select '0001','001',90
insert into sc select '0001','002',70
insert into sc s ......

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

±íÃû: teacher ×ֶηֱðÓÐ ÐòºÅ£¬ÐÕÃû£¬ÄêÁ䣬ÐÔ±ð£¬ÄêÊÕÈë¡­¡­¡­¡­
ÏÖÏëÇóÒ»ÌõSQLÓï¾äÊÇ ³ýÁË"ÐòºÅ"Õâ¸ö×ֶβ»ÏÔʾ,ÆäËû×ֶξùÏÔʾµÄÓï¾ä£¬ ²¢·Ç select ÐÕÃû£¬ÄêÁ䣬ÐÔ±ð£¬ÄêÊÕÈë¡­¡­¡­¡­
from teacher ÕâÌõÓï¾ä(ÒòΪ×ֶμÙÉèÓÐ30¶à¸ö»áдËÀÈ˵Ä)лл£¡
Óö¯Ì¬SQL

SQL code:
DECLARE @s VARCHAR(8000) ......

mysqlÖÐÈçºÎ²éѯ±íµÄ×ÜÁÐÊý - MS-SQL Server / »ù´¡Àà

±ÈÈçÒ»ÕűíÖÐÓÐname,idÁ½ÁÐ,ÒªµÃµ½2ÕâÑùµÄ½á¹û
Ö»ÒªsqlÓï¾ä,²»ÒªÆäËüµÄ³ÌÐòЭÖú
È¥mysqlµÄ°æÈ¥ÎÊ°É

ÎÒûÕÒµ½mysqlµÄ°æ,,,


ÒýÓÃ
È¥mysqlµÄ°æÈ¥ÎÊ°É
ͬÒâ.

ллjosy,ÎÒ¸ÕÕÒµ½mysql°æÇø,²»¹ýÎҵķֲ»¹»ÁË,ÓôÃÆ
......

mssqlµÄ¶à±í¹ØÁªÎÊÌâ - MS-SQL Server / »ù´¡Àà

a±íuid¡¢fidºÍb±íÖеÄid¹ØÁª£¬
ÈçºÎ²éѯa.uidºÍa.fid¶ÔÓ¦b±íÖеÄÏàÓ¦×ֶΡ£
SQL code:
select a.uid,a.fid,b.* from a,b where a.uid=b.id and a.fid=b.id

ÄãÊÇ˵b.idÊÇÓÉa.uid ºÍa.fid×é³ÉµÄ£¿
ÒªÊǵĻ°£¬
b.id = a.uid + a.fid 
ÕâÑùÐв»

ÓеãÃÔºý

ÒýÓÃ
a±íuid¡¢fidºÍb±íÖеÄid¹ØÁª£¬
ÈçºÎ² ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1] [2] 3 [4] [5] [6] [7] [8] [9] [10]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ