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

ËѼ¯µÄһЩLINQ to SQLµÄ×ÊÁÏ

MSDN: http://msdn.microsoft.com/en-us/library/bb386976.aspx £¨Ó¢ÎÄ£©
           http://msdn.microsoft.com/zh-cn/library/bb386976.aspx £¨ÖÐÎÄ£©
ScottGu µÄLINQ ϵÁУº
Part 1: Introduction to LINQ to SQL
Part 2: Defining our Data Model Classes
Part 3: Querying our Database
Part 4: Updating our Database
Part 5: Binding UI using the ASP:LinqDataSource Control
Part 6: Retrieving Data Using Stored Procedures
Part 7: Updating our Database using Stored Procedures
Part 8: Executing Custom SQL Expressions
Part 9 - Using a Custom LINQ Expression with the <asp:LinqDatasource> control


Ïà¹ØÎĵµ£º

[ת]SQL Server 2005 COM+ Ŀ¼ҪÇ󾯸æ

¢Ù¡£Æô¶¯Distributed Transaction Coordinator ·þÎñ
        ´ò¿ª·þÎñ£¬ÔÚ·þÎñÖÐÕÒµ½Distributed Transaction Coordinator·þÎñ£¬Ñ¡Ôñ“ÊôÐÔ”£»
        ÔÚ“µÇ¼”Ñ¡ÏÖУ¬Ñ¡Ôñ“´ËÕÊ»§”£¬ÕÊ»§ÃûÌîд“N ......

SQL SERVER index

×î½üÓÉÓÚϵͳµÄÐèÇó£¬ËùÒÔÒªÁ˽âÒ»ÏÂÈçºÎÓÅ»¯sql server£¬ÏÂÃæÊÇÎÒµÄһЩ×ܽᣬ²»×ãµÄµØ·½Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£ËµÒªÓÅ»¯´ó¼ÒÒ»¶¨»áÏëµ½Ë÷Òý£¬ÄÇÎÒÃǾʹÓË÷Òý¿ªÊ¼°É¡£ ΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)£¬ÏÂÃæ ......

SQLÖеÄLIKEÓï¾äµÄÓ÷¨

ÔÚSQL½á¹¹»¯²éѯÓïÑÔÖУ¬LIKEÓï¾äÓÐ×ÅÖÁ¹ØÖØÒªµÄ×÷Óá£
¡¡¡¡LIKEÓï¾äµÄÓï·¨¸ñʽÊÇ£ºselect * from ±íÃû where ×Ö¶ÎÃû like ¶ÔÓ¦Öµ£¨×Ó´®£©£¬ËüÖ÷ÒªÊÇÕë¶Ô×Ö·ûÐÍ×ֶεģ¬ËüµÄ×÷ÓÃÊÇÔÚÒ»¸ö×Ö·ûÐÍ×Ö¶ÎÁÐÖмìË÷°üº¬¶ÔÓ¦×Ó´®µÄ¡£
¡¡¡¡¼ÙÉèÓÐÒ»¸öÊý¾Ý¿âÖÐÓиö±ítable1£¬ÔÚtable1ÖÐÓÐÁ½¸ö×ֶΣ¬·Ö±ðÊÇnameºÍsex¶þÕßÈ«ÊÇ×Ö·ûÐÍÊý¾ ......

sys.tables£¨sql server 2005£©

Ϊÿ¸ö±í¶ÔÏó·µ»ØÒ»ÐС£µ±Ç°½öÓÃÓÚ sys.objects.type = U µÄ±í¶ÔÏó¡£
ÁÐÃû Êý¾ÝÀàÐÍ ËµÃ÷
<¼Ì³ÐµÄÁÐ>
 
ÓйشËÊÓͼËù¼Ì³ÐµÄÁеÄÁÐ±í£¬Çë²ÎÔÄ sys.objects
lob_data_space_id
int
Ò»¸ö·ÇÁãÖµ£¬ÊDZ£´æ´Ë±íµÄ text¡¢ntext ºÍ image Êý¾ÝµÄ´ÅÅ̿ռ䣨Îļþ×é»ò·ÖÇø¼Ü¹¹£©µÄ ID¡£
0 = ±í²»°üº¬ text¡¢ntext ......

¡¶sql ÓïÑÔÒÕÊõ¡· ¸ÅÒª

http://www.oreilly.com/catalog/artofsql £¨Ô­Ê飩
http://www.oreilly.com.cn/book.php?bn=978-7-121-05834-9 (ÖÐÎİæ)
  Êý¾Ý¿â¼¼ÊõÊÇÆóÒµÐÅÏ¢»¯¿ª·¢µÄ»ù´¡¡£ÔÚÖÆÔìÒµÐÅÏ¢»¯ÁìÓò´ÓÒµ¶àÄ꣬×Ô¼º¶ÔÕâ¿é֪ʶȴһֱÁãËéÔÓÂÒ£¬Ó¦¸ÃÀí˳˼·£¬Îª¼Ü¹¹Éè¼ÆµÄÄ¿±ê½¨Á¢»ù´¡¡£
       ´ËÊé ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ