특정 테이블의 컬럼 조회하기
별 것 아니긴 한데, 회사 동료가 쿼리 좀 만들어 달라기에 한번 해봤습니다. DECLARE @tablename sysname SET @tablename=‘companyinfo’ SELECT c.[name] AS column_name FROM dbo.sysobjects AS o WITH (READUNCOMMITTED) JOIN dbo.syscolumns AS…
별 것 아니긴 한데, 회사 동료가 쿼리 좀 만들어 달라기에 한번 해봤습니다. DECLARE @tablename sysname SET @tablename=‘companyinfo’ SELECT c.[name] AS column_name FROM dbo.sysobjects AS o WITH (READUNCOMMITTED) JOIN dbo.syscolumns AS…
원격 컴퓨터에 Trusted Connection을 할 수 없는 환경에서는 사용의 제한이 따르는군요. 즉 원격 컴퓨터의 이름이 아니라 IP Address를 넣어야 하는 경우엔 제대로 작동하지 않습니다. 각 컴퓨터의 설정에 따라 미묘하게 작동방식이…
Vyaskn‘s object naming conventions are very different from mine. However, I can see the reason in his conventions. Mayhaps I will adopt his proposal someday, but now I have to…
I’ve found the document about naming convention of database programming from Vyas’s blog. His suggestion is very similar to mine. You can read original document below. Databases are the heart…
This document is written in Korean by Chun-Sik Lee. He gives us good advices. If you are interested in Data Architecture and are able to read Korean language ‘Hangul’, read…
On friday, I will take a test for MCBDA certification. I’ve already passed 070-229 test 2 weeks ago. This time, I registerd for ‘[070-228] Installing, Configuring, and Administering Microsoft SQL…
지난 금요일에 연봉 협상을 했다. 회사에서 일한 지 이제 9개월이 막 넘었을 뿐이다. 하지만 그 동안 평가 면에서도 계속 상위권이었고, 큰 프로젝트 몇 개를 성공적으로 마쳤다. 그 중 하나는 수익이…
When I was googling, I found one useful .Net development community. People are very active. There are a lot of posts and comments concerning various topics about .Net technology. Besides,…
When I first start test-driven development, I got in trouble. Assembly that I was developing used a configuration file named ‘app.config’. However, whenever I tested the functionality of my assembly,…