TanSanC

MSSQL 테이블명, 컬럼명 검색

-- 테이블명 검색

SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME = '테이블명'

-- 컬럼명 검색

SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME = '컬럼명'

-- PK 검색

SELECT * FROM information_schema.KEY_COLUMN_USAGE

pjsip Building for Microsoft Windows

출처 : https://trac.pjsip.org/repos/wiki/Getting-Started/Windows

Build Preparation for Windows

1. Get the source code, if you haven't already.
2. It is important that you create a config_site.h as described in Build Preparation

Building the Projects

Follow the steps below to build the libraries/application using Visual Studio:

1. For Visual Studio 6/2002/2003: open pjproject.dsw workspace file. (No longer supported since pjsip 2.0)
2. For Visual Studio 8 (VS 2005): open pjproject-vs8.sln solution file.
3. For Visual Studio 9 (VS 2008): open pjproject-vs8.sln solution file. One-time conversion of projects to VS 2008 format will done automatically.
4. For Visual Studio 11 (VS 2012): open pjproject-vs8.sln solution file. One-time conversion of projects to VS 2012 format will done automatically.
   1. Warnings about Windows Mobile projects/configurations can be safely ignored, VS 2012 does not support Windows Mobile
   2. Additional tips from ​pjsip mailing list
5. Set pjsua as Active or Startup Project.
6. Set Win32 as the platform.
7. Select Debug or Release build as appropriate.
8. Build the project. This will build pjsua application and all libraries needed by pjsua.
9. After successful build, the pjsua application will be placed in pjsip-apps/bin directory, and the libraries in lib directory under each projects.

To build the samples:

1. (Still using the same workspace)
2. Set samples project as Active Project
3. Select Debug or Release build as appropriate. See Visual Studio Build Configuration page for explanation of each provided build configuration
4. Build the project. This will build all sample applications and all libraries needed.
5. After successful build, the sample applications will be placed in pjsip-apps/bin/samples directory, and the libraries in lib directory under each projects.