Friday, August 15, 2014

DNS 모음

Google Public DNS
https://developers.google.com/speed/public-dns/
8.8.8.8
8.8.4.4

Level 3 Communication
http://www.level3.com/
4.2.2.2
4.2.2.1

Open DNS
http://www.opendns.com/
208.67.222.222
208.67.222.220

Comodo Secure DNS
http://www.comodo.com/secure-dns/
8.26.56.26
8.20.247.20

Norton Connect Safe
https://dns.norton.com/faq.html
199.85.126.10
199.85.127.10

Korea KT
168.126.63.1
168.126.63.2

Korea LG
164.124.107.9
203.248.242.2

Korea SK
219.250.36.130
210.220.163.82



MS-SQL : ROW_NUMBER 순번으로 WHERE 찾기


SELECT ranks,field1,field2
  FROM(
       SELECT ROW_NUMBER() OVER (ORDER BY field1,field2 ASC) AS ranks
             ,field1
             ,field2
         FROM TABLE_NAME
      ) A
 WHERE ranks = 18
 ORDER BY field1,field2 ASC

MS-SQL : 다른 DB 에서 SELECT 한걸 INSERT

insert into COPY_TABLE_NAME
select FIELD1,FIELD2,FIELD3,FIELD4,FIELD5 
  from [127.0.0.1].[DBNAME].[dbo].[ORIGINAL_TABLE_NAME]