ÐÞ¸ÄSQL 2005Êý¾Ý¿âĬÈϲ»Çø·Ö´óСд
´´½¨µÄÊý¾Ý¿âÖÐÇø·Ö´óСд
create database test COLLATE Chinese_PRC_CS_AS
Êý¾Ý¿âÖÐÇø·Ö´óСд
alter database test COLLATE Chinese_PRC_CS_AS
»Ö¸´Ä¬ÈϵIJ»Çø·Ö´óСд
alter database test COLLATE Chinese_PRC_CI_AS
Ïà¹ØÎĵµ£º
exists £¨sql ·µ»Ø½á¹û¼¯ÎªÕ棩
not exists (sql ²»·µ»Ø½á¹û¼¯ÎªÕ棩
ÈçÏ£º
±íA
ID NAME
1 A1
2 A2
3 A3
±íB
ID AID NAME
1 1 B1
2 & ......
ADO.net£¬Linq to SQLºÍEntity FrameworkÐÔÄÜʵ²â·ÖÎö
¡¡¡¡×î½üÎĵµÐ´Á˲»ÉÙ£¬µ¼ÖÂWordºÍExcelµÄʹÓÃÄÜÁ¦·ÉÒ»°ã³É³¤¡£¿¼Âǵ½ÏîÄ¿ÖжÁдÊý¾Ý¿âµÄ·½·¨´æÔÚЧÂʲ»¸ß£¬ÒÔÖÂÓ°ÏìÓû§ÌåÑéµÄÎÊÌ⣬¾ö¶¨²âÊÔÒ»ÏÂMicrosoftÐÂÍÆÐеÄLinqºÍEFÄܲ»ÄÜÔÚЧÂÊÉÏÓÐËù¸Ä½ø¡£
¡¡¡¡²âÊÔ»·¾³µ±È»¾ÍÊÇÎÒÕą̂±Ê¼Ç±¾ÁË£¬ÊÜÏÞÓëÓ²ÅÌתËÙ£¬ÔËÐÐÆð ......
µÚÒ»ÖÖ£º
select b.* from
( select a.*, rownum row_num from
(select t.* from A05_ORGANIZATION t order by org_name_en asc) a
) b
where b.row_num between 1 and 5 order by b.row_num asc
µÚ¶þÖÖ£¨¸ü¸ßЧ£©£º
select b.* from
( select a.*, rown ......
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ, ¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ ......