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

linq to sql ÖеÄin ²Ù×÷ʵÏÖ


        string s = " 80,81,83,82";
        string[] s1 = s.Split(',');
        int[] p = new int[s1.Count()];
        for (int i = 0; i < s1.Count(); i++)
        {
            p.SetValue(Convert.ToInt32(s1[i]), i);
        }
       
       
       
        public IQueryable<tbQuestions> SelectQuestions(int[] p)
        {
            var result = from s1 in db.tbQuestions
                         where !p.Contains(s1.id) && s1.deleteFlag == 0
                         select s1;
            return result;
        }


Ïà¹ØÎĵµ£º

sql ʱ¼ä¸ñʽת»»

Óï¾ä¼°²éѯ½á¹û£º
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3): 16/05/06
SELECT CONVERT(varchar(100), GETDATE(), 4): 16.05.06
SE ......

SQL ServerÊÂÎñÈÕÖ¾µÄ¼¸¸ö³£ÓòÙ×÷ [ת]

ÎÒÃÇÖªµÀ£¬SQL ServerÊÂÎñÈÕÖ¾Ö÷ÒªÊÇÓÃÀ´¼Ç¼ËùÓÐÊÂÎñ¶ÔÊý¾Ý¿âËù×öµÄÐ޸ģ¬Èç¹ûϵͳ³öÏÖ¹ÊÕÏ£¬Ëü½«³ÉΪ×îÐÂÊý¾ÝµÄΨһÀ´Ô´¡£ÈÕÖ¾µÄ²Ù×÷³£ÓÐÒÔϼ¸¸öÓ¦Óãº
Ò»¡¢ÊÂÎñÈÕÖ¾ÎļþLDFµÄ¶ªÊ§
µ±ÎÒÃDz»Ð¡É¾³ý»òÕßLDFÎļþ¶ªÊ§µÄʱºò£¬Êý¾Ý¿âֻʣÏÂMDFÎļþ£¬´Ëʱֱ½Óͨ¹ý¸½¼ÓMDFÊÇÎÞ·¨»Ö¸´Êý¾Ý¿âµÄ£¬ÄÇÎÒÃÇÔõôÑù²ÅÄָܻ´Êý¾Ý¿âÄØ?Î ......

javaÁ´½Ósql server

Ô­Ìû¼°ÌÖÂÛ£ºhttp://bbs.bc-cn.net/dispbbs.asp?boardid=12&id=140292
*   ×î½üÒòΪ¿ª·¢»î¶¯ÐèÒª,ÓÃÉÏÁËEclipse,²¢ÒªÇóʹÓþ«¼ò°æµÄSQLÊý¾Ý¿â(¼´SQL   Server   2005)À´½øÐпª·¢ÏîÄ¿   *
1.×¼±¸¹¤×÷:   ×¼±¸Ïà¹ØµÄÈí¼þ(Eclipse³ýÍâ,¿ªÔ´Èí¼þ¿ÉÒÔ´Ó¹ÙÍøÏÂÔØ)
<1> .Microsoft   ......

»ñÈ¡SQL ServerÔªÊý¾Ý·½·¨

ÔªÊý¾Ý¼ò½é
¡¡¡¡ÔªÊý¾Ý (metadata) ×î³£¼ûµÄ¶¨ÒåΪ"ÓйØÊý¾ÝµÄ½á¹¹Êý¾Ý"£¬»òÕßÔÙ¼òµ¥Ò»µã¾ÍÊÇ"¹ØÓÚÊý¾ÝµÄÐÅÏ¢"£¬ÈÕ³£Éú»îÖеÄͼÀý¡¢Í¼Êé¹ÝĿ¼¿¨ºÍÃûƬµÈ¶¼¿ÉÒÔ¿´×÷ÊÇÔªÊý¾Ý¡£ÔÚ¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ (DBMS) ÖУ¬ÔªÊý¾ÝÃèÊöÁËÊý¾ÝµÄ½á¹¹ºÍÒâÒå¡£±ÈÈçÔÚ¹ÜÀí¡¢Î¬»¤ SQL Server »òÕßÊÇ¿ª·¢Êý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃǾ­³£Òª»ñ ......

SQL×¢ÈëÕûÀí

£Ó£Ñ£Ì×¢ÈëÊÇ´ÓÕý³£µÄWWW¶Ë¿Ú·ÃÎÊ£¬¶øÇÒ±íÃæ¿´ÆðÀ´¸úÒ»°ãµÄWebÒ³Ãæ·ÃÎÊÃ»Ê²Ã´Çø±ð£¬ ËùÒÔĿǰÊÐÃæµÄ·À»ðǽ¶¼²»»á¶Ô£Ó£Ñ£Ì×¢Èë·¢³ö¾¯±¨£¬Èç¹û¹ÜÀíԱû²é¿´IISÈÕÖ¾µÄϰ¹ß£¬¿ÉÄܱ»ÈëÇֺܳ¤Ê±¼ä¶¼²»»á·¢¾õ¡£
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ