8월, 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]