Knowledge Sharing of My Experience

Check Bandwidth telnet [ip router] #username and password #sh int [interface=s0/0,f0/0] Edit Configuration #en #password แสดง IP Route #show ip route Show QOS Policy #show policy-map interface Show Access-List #show access-lists Add New Access-list #en #conf t #access-list 101 permit ip host 10.10.10.9 any #access-list 101 permit ip any host 10.10.20.9 #access-list 101 permit tcp host 10.10.10.8 eq ftp any Delete Access-list #en #conf t #no access-list 101 Show cache flow #show ip cache flow include 10.10.10.9 Update Bandwidth priority of policy-map #conf t #policy-map QOS #class FAX #priority 64

– Microsoft SQL Server T-SQL date and datetime formats – Date time formats – mssql datetime  – MSSQL getdate returns current system date and time in standard internal format SELECT   convert ( varchar ,   getdate (),  100 )   – mon dd yyyy hh:mmAM (or PM)                                          – Oct  2 2008 11:01AM           SELECT   convert ( varchar ,   getdate (),  101 )   – mm/dd/yyyy  -  10/02/2008                   SELECT   convert ( varchar ,   getdate (),  102 )   – yyyy.mm.dd – 2008.10.02            SELECT   convert ( varchar ,   getdate (),  103 )   – dd/mm/yyyy SELECT   convert ( varchar ,   getdate (),  104 )   – dd.mm.yyyy SELECT   convert ( varchar ,   getdate (),  105 )   – dd-mm-yyyy SELECT   convert ( varchar ,   getdate (),  106 )   – dd mon yyyy SELECT   convert ( varchar ,   getdate (),  107 )   – mon dd, yyyy SELECT   convert ( varchar ,   getdate (),  108 )   – hh:mm:ss SELECT   convert ( varchar ,   getdate (),  109 )   – mon dd yyyy