Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ :

Linuxϳ£ÓÃCÓïÑÔ×Ö·û´®²Ù×÷º¯Êý

stroul£¬
strdup
snprintf()
atio
 
CÖг£ÓÃ×Ö·û´®²Ù×÷º¯Êý
#include <string.h>
 
size_t strlen(const char *s)   ²âÁ¿×Ö·û´®³¤¶ÈsµÄʵ¼Ê³¤¶È¡£
ÀýÈçs[20]="abc",ÄÇôstrlen(s)µÄ½á¹ûÊÇ3£¬¶ø²»ÊÇ20.Õâ¾ÍÊÇʵ¼Ê³¤¶È
 
char *strcat(const char *s1, const *s2)    ½«×Ö·û´®s2Á¬½Óµ½s1µÄβ²¿¡£´Ós1µÄ\0¿ªÊ¼¡£
 
int strcmp(const *s1,const *s2)  ±È½Ïs1ºÍs2¡£
s1 = s2µÄʱºò·µ»ØÖµ =0
s1 < s2µÄʱºò·µ»ØÖÁ <0
s1 > s2µÄʱºò·µ»ØÖµ >0
 
char *strchr(const char *s, char c);  ·µ»ØsÖÐÊ״γöÏÖCµÄλÖõÄÖ¸Õë¡£Èç¹ûsÖв»´æÔÚcÔò·µ»ØNULL
 
char *strrchr(const char *s, char c );·µ»ØsÖÐ×îºóÒ»´Î³öÏÖcµÄλÖõÄÖ¸Õë¡£Èç¹ûûÓУ¬Ôò·µ»Ø0
 
char *strstr(const char *haystack, const char *needle);·µ»ØhaystackÖÐneedle×Ö·û´®Ê״γöÏÖµÄλÖõÄÖ¸Õ루²»±È½Ï½áÊø·ûNULL£©¡£Èô¹ûûÕÒµ½Ôò·µ»ØNULL
 
 
ÏÞ¶¨³¤¶ÈµÄ±È½Ï£¬¿½±´ºÍ×·¼Óº¯Êý
int strncmp(char *s1, const char *s2, size_t n);(ÕâЩ¶¼ÊÇÕë¶Ô×Ö·û´®µÄǰn¸ö×Ö·ûÀ´²Ù×÷µÄ)
  ......

Linuxϳ£ÓÃCÓïÑÔ×Ö·û´®²Ù×÷º¯Êý

stroul£¬
strdup
snprintf()
atio
 
CÖг£ÓÃ×Ö·û´®²Ù×÷º¯Êý
#include <string.h>
 
size_t strlen(const char *s)   ²âÁ¿×Ö·û´®³¤¶ÈsµÄʵ¼Ê³¤¶È¡£
ÀýÈçs[20]="abc",ÄÇôstrlen(s)µÄ½á¹ûÊÇ3£¬¶ø²»ÊÇ20.Õâ¾ÍÊÇʵ¼Ê³¤¶È
 
char *strcat(const char *s1, const *s2)    ½«×Ö·û´®s2Á¬½Óµ½s1µÄβ²¿¡£´Ós1µÄ\0¿ªÊ¼¡£
 
int strcmp(const *s1,const *s2)  ±È½Ïs1ºÍs2¡£
s1 = s2µÄʱºò·µ»ØÖµ =0
s1 < s2µÄʱºò·µ»ØÖÁ <0
s1 > s2µÄʱºò·µ»ØÖµ >0
 
char *strchr(const char *s, char c);  ·µ»ØsÖÐÊ״γöÏÖCµÄλÖõÄÖ¸Õë¡£Èç¹ûsÖв»´æÔÚcÔò·µ»ØNULL
 
char *strrchr(const char *s, char c );·µ»ØsÖÐ×îºóÒ»´Î³öÏÖcµÄλÖõÄÖ¸Õë¡£Èç¹ûûÓУ¬Ôò·µ»Ø0
 
char *strstr(const char *haystack, const char *needle);·µ»ØhaystackÖÐneedle×Ö·û´®Ê״γöÏÖµÄλÖõÄÖ¸Õ루²»±È½Ï½áÊø·ûNULL£©¡£Èô¹ûûÕÒµ½Ôò·µ»ØNULL
 
 
ÏÞ¶¨³¤¶ÈµÄ±È½Ï£¬¿½±´ºÍ×·¼Óº¯Êý
int strncmp(char *s1, const char *s2, size_t n);(ÕâЩ¶¼ÊÇÕë¶Ô×Ö·û´®µÄǰn¸ö×Ö·ûÀ´²Ù×÷µÄ)
  ......

Linuxϳ£ÓÃCÓïÑÔ×Ö·û´®²Ù×÷º¯Êý

stroul£¬
strdup
snprintf()
atio
 
CÖг£ÓÃ×Ö·û´®²Ù×÷º¯Êý
#include <string.h>
 
size_t strlen(const char *s)   ²âÁ¿×Ö·û´®³¤¶ÈsµÄʵ¼Ê³¤¶È¡£
ÀýÈçs[20]="abc",ÄÇôstrlen(s)µÄ½á¹ûÊÇ3£¬¶ø²»ÊÇ20.Õâ¾ÍÊÇʵ¼Ê³¤¶È
 
char *strcat(const char *s1, const *s2)    ½«×Ö·û´®s2Á¬½Óµ½s1µÄβ²¿¡£´Ós1µÄ\0¿ªÊ¼¡£
 
int strcmp(const *s1,const *s2)  ±È½Ïs1ºÍs2¡£
s1 = s2µÄʱºò·µ»ØÖµ =0
s1 < s2µÄʱºò·µ»ØÖÁ <0
s1 > s2µÄʱºò·µ»ØÖµ >0
 
char *strchr(const char *s, char c);  ·µ»ØsÖÐÊ״γöÏÖCµÄλÖõÄÖ¸Õë¡£Èç¹ûsÖв»´æÔÚcÔò·µ»ØNULL
 
char *strrchr(const char *s, char c );·µ»ØsÖÐ×îºóÒ»´Î³öÏÖcµÄλÖõÄÖ¸Õë¡£Èç¹ûûÓУ¬Ôò·µ»Ø0
 
char *strstr(const char *haystack, const char *needle);·µ»ØhaystackÖÐneedle×Ö·û´®Ê״γöÏÖµÄλÖõÄÖ¸Õ루²»±È½Ï½áÊø·ûNULL£©¡£Èô¹ûûÕÒµ½Ôò·µ»ØNULL
 
 
ÏÞ¶¨³¤¶ÈµÄ±È½Ï£¬¿½±´ºÍ×·¼Óº¯Êý
int strncmp(char *s1, const char *s2, size_t n);(ÕâЩ¶¼ÊÇÕë¶Ô×Ö·û´®µÄǰn¸ö×Ö·ûÀ´²Ù×÷µÄ)
  ......

Linuxϳ£ÓÃCÓïÑÔ×Ö·û´®²Ù×÷º¯Êý

stroul£¬
strdup
snprintf()
atio
 
CÖг£ÓÃ×Ö·û´®²Ù×÷º¯Êý
#include <string.h>
 
size_t strlen(const char *s)   ²âÁ¿×Ö·û´®³¤¶ÈsµÄʵ¼Ê³¤¶È¡£
ÀýÈçs[20]="abc",ÄÇôstrlen(s)µÄ½á¹ûÊÇ3£¬¶ø²»ÊÇ20.Õâ¾ÍÊÇʵ¼Ê³¤¶È
 
char *strcat(const char *s1, const *s2)    ½«×Ö·û´®s2Á¬½Óµ½s1µÄβ²¿¡£´Ós1µÄ\0¿ªÊ¼¡£
 
int strcmp(const *s1,const *s2)  ±È½Ïs1ºÍs2¡£
s1 = s2µÄʱºò·µ»ØÖµ =0
s1 < s2µÄʱºò·µ»ØÖÁ <0
s1 > s2µÄʱºò·µ»ØÖµ >0
 
char *strchr(const char *s, char c);  ·µ»ØsÖÐÊ״γöÏÖCµÄλÖõÄÖ¸Õë¡£Èç¹ûsÖв»´æÔÚcÔò·µ»ØNULL
 
char *strrchr(const char *s, char c );·µ»ØsÖÐ×îºóÒ»´Î³öÏÖcµÄλÖõÄÖ¸Õë¡£Èç¹ûûÓУ¬Ôò·µ»Ø0
 
char *strstr(const char *haystack, const char *needle);·µ»ØhaystackÖÐneedle×Ö·û´®Ê״γöÏÖµÄλÖõÄÖ¸Õ루²»±È½Ï½áÊø·ûNULL£©¡£Èô¹ûûÕÒµ½Ôò·µ»ØNULL
 
 
ÏÞ¶¨³¤¶ÈµÄ±È½Ï£¬¿½±´ºÍ×·¼Óº¯Êý
int strncmp(char *s1, const char *s2, size_t n);(ÕâЩ¶¼ÊÇÕë¶Ô×Ö·û´®µÄǰn¸ö×Ö·ûÀ´²Ù×÷µÄ)
  ......

¡¶LINUXÉ豸Çý¶¯³ÌÐò¡·Ñ§Ï°Ôý¼Ç£¨Ò»£©

×ܽáÕ½ڣºµÚÒ»Õ É豸Çý¶¯³ÌÐò¼ò½é
          µÚ¶þÕ ¹¹ÔìºÍÔËÐÐÄ£¿é
Ìáµ½Çý¶¯³ÌÐò¾Í²»µÃ²»ÏÈ˵ÏÂÁ½¸öÃû´Ê£ºÄں˿ռäºÍÓû§¿Õ¼ä¡£Óû§¿Õ¼ä¼´Óû§Ó¦ÓÃËùÔËÐеĿռ䣬Äں˿ռäÖµµÃÊDzÙ×÷ϵͳÄÚºËÔËÐеĿռ䡣Óû§¿Õ¼ä²»ÄÜÖ±½ÓÒýÓûòÕß²Ù×÷Äں˿ռäµÄÊý¾Ý£¬Äں˿ռäÒ²²»ÄÜÖ±½ÓÒýÓÃÓû§¿Õ¼äµÄÊý¾Ý¡£²Ù×÷ϵͳÄں˶ÔÕû¸öϵͳ×ÊÔ´½øÐйÜÀí£¬ÕâЩ×ÊÔ´ÖÐÒ²°üÀ¨Ó²¼þ×ÊÔ´¡£ËùÒÔÓû§¿Õ¼äÒ²²»ÄÜÖ±½Ó·ÃÎÊÓ²¼þ×ÊÔ´¡£Çý¶¯ÎªÓû§·ÃÎÊÌØ¶¨µÄÓ²¼þ×ÊÔ´Ìṩ½Ó¿Ú¡£Óû§¿Õ¼äÒª·ÃÎÊÓ²¼þ×ÊÔ´ÔòÖ»ÐèÒªµ÷ÓÃÇý¶¯ËùÌṩµÄ½Ó¿Ú¡£Çý¶¯ÍêÈ«ÆÁ±ÎÁËÄÚ²¿²Ù×÷¡£´Ó¶ø£¬Óû§¿Õ¼äͨ¹ýÇý¶¯Õâ²ãÌØÊâµÄÄں˼ä½ÓµÄ·ÃÎÊÓ²¼þ×ÊÔ´¡£
Çý¶¯µÄ×÷ÓÃÔÚÓÚÌṩ»úÖÆ£¬»úÖÆ¼´£ºÐèÒªÌṩʲô¹¦ÄÜ£¬¶ø²»ÊÇÌṩ²ßÂÔ£¬²ßÂÔ¼´£ºÈçºÎʹÓÃÕâЩ¹¦ÄÜ¡£Ìṩ»úÖÆÊÇÇý¶¯³ÌÐòµÄÈÎÎñ£¬¶ø²ßÂÔÔòÊÇÓ¦ÓóÌÐòËùÒªÍê³ÉµÄÈÎÎñ¡£ÓÉÓÚ²»Í¬µÄ»·¾³»áÓв»Í¬µÄ·½Ê½À´·ÃÎÊÓ²¼þ£¬×÷ΪÇý¶¯³ÌÐòµÄ±àдÕߣ¬Ó¦¸Ã¾¡Á¿×öµ½Ê¹Çý¶¯²»µ½²ßÂÔ£¬ÔÚ±àдÇý¶¯µÄʱºò£¬³ÌÐòÔ±»¹Ó¦¸ÃÌØ±ð×¢Ò⣬±àд·ÃÎÊÓ²¼þµÄÄں˴úÂ룬²»Òª¸øÓû§Ç¿¼ÓÈκÎÌØ¶¨²ßÂÔ¡£ÒòΪ²»Í¬µÄÓû§»áÓв»Í¬µÄÐèÇó¡£
Äں˵ŦÄÜ·ÖΪ£º½ø³Ì¹ÜÀí£¬ÄÚ´æ¹ÜÀí£¬ÎļþÏµÍ ......

LinuxÉÏautofsÅäÖü°Æä˵Ã÷....

             °æÈ¨ÉùÃ÷£ºÔ­´´×÷Æ·£¬ÔÊÐí×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ ԭʼ³ö´¦ ¡¢×÷ÕßÐÅÏ¢ºÍ±¾ÉùÃ÷¡£·ñÔò½«×·¾¿·¨ÂÉÔðÈΡ£http://blog.csdn.net/Neverland2012  
         ÎÒÃǾ­³£»áÈ¥ÏÂÔØ±ðµÄ·þÎñÆ÷ÉϵĶ«Î÷..»òÕß¹ÒÔØ±¾µØµÄĿ¼µ½Ò»ÁíÒ»¸öĿ¼Ö÷ҪΪÁË·ÃÎÊÆðÀ´·½±ã·¾¶ÈÝÒ×¼Çס.Õâ¸ö·þÎñÖ÷ÒªÓÐÁ½¸öÅäÖÃÎļþÒ»¸öÊÇ/etc/auto.master.Õâ¸öÎļþ¶¨ÒåÁ˹ÒÔØµÄ¹ÒÔØµãºóÃæ½ô¸ú×Åmount¶¯×÷...ÁíÒ»¸öÊÇ/etc/auto.misc,Õâ¸öÎļþ¶¨Òå¹ÒÔØµÄµØ·½ÒÔ¼°±»¹ÒÔÚµÄĿ¼.´ËĿ¼¿ÉÒÔÊÇÔ¶³Ì·þÎñÆ÷ÉϵÄĿ¼Ҳ¿ÉÒÔÊDZ¾µØÄ¿Â¼.....ÎÒÃÇ¿ÉÒÔ¼ä½ÓÀ´½øÐÐÓ³ÉäÔ¶³Ì»úÆ÷ÉϵÄĿ¼µ½±¾»ú,Ò²¿ÉÖ±½ÓÓ³Éä±¾µØµÄĿ¼...
        ÏÂÃæÎÒÀ´¸ø´ó¼ÒÏêϸ½²½â¼ä½ÓÓ³ÉäÔ¶³Ì»úÆ÷Ŀ¼µ½±¾µØµÄĿ¼.......ÏÈ¿´¿´¿´/etc/auto.masterµÄÅäÖÃÎļþ
#
# $Id: auto.master,v 1.4 2005/01/04 14:36:54 raven Exp $
#
# Sample auto.master file
# This is an automounter map and it has the following format
# key [ -mount-options-separated-by-comma ......

ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«

Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º 
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
  from ±íÃû
  ORDER BY ID))
  ORDER BY ID
//×Ô¼º»¹¿ÉÒÔ¼ÓÉÏһЩ²éѯÌõ¼þ
Àý:
select top 2 *
from Sys_Material_Type
where (MT_ID not in
    (select top (2*(3-1)) MT_ID from Sys_Material_Type  order by MT_ID))
order by MT_ID
2.·ÖÒ³·½°¸¶þ£º(ÀûÓÃID´óÓÚ¶àÉÙºÍSELECT TOP·ÖÒ³£©
Óï¾äÐÎʽ£º
SELECT TOP ÿҳ¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID >
          (SELECT MAX(id)
    from (SELECT TOP ÿҳÐÐÊý*Ò³Êý id  from ±í
          ORDER BY id) AS T)
      )
ORDER BY ID
Àý:
SELECT TOP 2 *
from Sys_Material_Type
WHERE (MT_ID >
          (SELECT MAX(MT_ID)
  & ......

ÈçºÎÐÞ¸ÄSQL Server 2000µÄÊý¾Ý¿âÂß¼­ÓëÎïÀíÃû³Æ

ÔÚÏîÄ¿ÖÐʹÓÃSQL Server 2000´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬·¢ÏÖÃû³ÆÓëÁíÒ»¸öÊý¾Ý¿âÌ«ÏàËÆ£¬ÓÚÊǾö¶¨¸ü¸ÄÃû³Æ£¬°üÀ¨£º
ÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½µÄÊý¾Ý¿âÃû£¬Ò²ÊÇʵ¼ÊÓ¦ÓóÌÐòÖÐÁ¬½ÓÓõÄÊý¾Ý¿âÃû³Æ£»
ÔÚ´ÅÅÌÉÏ¿´µÄÎïÀíÃû³Æ¡£
¸ù¾Ý¹úÄÚÍâÕÒµ½µÄ¼¼Êõ×ÊÁÏ£¬¸ø³öÍêÕûµÄSQL½Å±¾´úÂëÈçÏ£¨Ô­¿âÃûΪabc¡¢ÐÞ¸ÄΪabc2£©£º
use master 
go 
--1) ´´½¨Êý¾Ý¿â(ԭʼÊý¾Ý¿âabc)
create database abc on(name='abc', filename='d:\abc_data.mdf') 
go 
--2) ÖØÃüÃûÊý¾Ý¿â(ÐÂÊý¾Ý¿âÃûabc2)
exec sp_renamedb abc, abc2
go 
--3) ÐÞ¸ÄÊý¾Ý¿âµÄÂß¼­Ãû³Æ
alter database abc2 modify file(name='abc_data', newname='abc2_data')
alter database abc2 modify file(name='abc_log',  newname='abc2_log')
--go
--4) ·ÖÀëÊý¾Ý¿â
exec sp_detach_db abc2
go 
--5) ÖØÃüÃûÊý¾Ý¿âÎïÀíÎļþ
exec xp_cmdshell 'rename  d:\abc_data.mdf abc2_data.mdf' 
exec xp_cmdshell 'rename  d:\abc_log.ldf  abc2_log.ldf' 
go 
--6) ¸½¼ÓÊý¾Ý¿â
exec sp_attach_db 'abc2', 'd:\abc2_data.mdf', 'd:\abc2_log.ldf'
go
ÉÏÊö´ú ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2944] [2945] [2946] [2947] 2948 [2949] [2950] [2951] [2952] [2953]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ