linq »ñÈ¡Êý¾Ý¿âʱ¼ä »òÕßÖ´ÐÐÆäËû´ø·µ»ØÖµµÄsql²éѯ
using (LongXingDBDataContext db = new LongXingDBDataContext())
{
DeviceInfo di;
di = new DeviceInfo();
var a = db.ExecuteQuery<DateTime>("select getdate()",new object[] {});
di.CreateDate = a.First();
db.DeviceInfo.InsertOnSubmit(di);
db.SubmitChanges();
this.toolTip1.Show("±£´æÍê±Ï", this, ((Control)sender).Location, 2000);
}
Ïà¹ØÎĵµ£º
Access µÄ SQL ÖУ¬¼ÆËãÏàÓ¦±àºÅµÄ¼Ç¼֮¼ä ¼Ó ¼õ µÄ²éѯÃüÁî
ÀýÈç ¼ÆËãIDΪ 6 µÄ ºÏ¼Æ ¼õÈ¥ ID Ϊ 2¡¢3¡¢4 ÒÔ¼°¼ÓÉÏ ID Ϊ 5 µÄºÏ¼Æ
SELECT SUM(R) AS ½á¹û
from
(
SELECT ºÏ¼Æ AS R from T1 WHERE (ID = 6) UNION
SELECT -ºÏ¼Æ AS R from T1 WHERE (ID = 2) UNION
SELECT -ºÏ¼Æ AS R f ......
select top PageSize * from ±í
where Ìõ¼þ and id not in
(select top PageSize*(CurrentPageIndex-1) id from ±í where Ìõ¼þ order by ÅÅÐòÌõ¼þ)
order by ÅÅÐòÌõ¼þ
¡¶PageSize ÊÇGridViewÖÐÿҳÏÔʾµÄÐÅÏ¢ÌõÊý£¬PageSize*(CurrentPageIndex-1) ÔÚSQLÖв»Ê¶±ð£¬Ð趨Òå±äÁ¿À´Ìæ»»¡· ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
Çø×¨ÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
Ô´Ìù£ºhttp://topic.csdn.net/u/20100417/19/ebdc216a-acc9-4e04-80f3-dbada0b4f3fe.html?74846
Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float
Status bit
Êý¾ÝÈçÏ£º
Code CreateTime Price Status
031002 2008-10-17 ......
ÀûÓÃSQL2000µÄ¶¨Ê±±¸·Ý¹¦ÄÜ£¬ÄܺܺöԷþÎñÆ÷ÉϵÄÖØÒªÊý¾ÝÐÅÏ¢½øÐÐÍêÕûµÄ¶¨Ê±±¸·Ý£¬ÒÔ±ãÔÚ·þÎñÆ÷̱»¾»òÊý¾Ý¿â³öÏÖËð»µÊ±¼°Ê±µÄ½øÐлָ´¹¤×÷£¬ÒÔÈ·±£Æ½Ê±µÄ¹¤×÷ÄÜÕý³£µÄ½øÐС£ÏÂÃæÏò´ó¼Ò½éÉÜÒ»ÏÂSQL2000¶¨ÆÚ±¸·ÝµÄÉèÖ÷½·¨£¬¾ßÌåÈçÏ£º
1. ´ò¿ªSQL2000µÄÆóÒµ¹ÜÀíÆ÷
2.&nbs ......