[DATABASE/SQLSERVER] 동적 SQL 실행하기

■ 동적으로 SQL을 실행하는 방법을 보여준다.

▶ 예제 코드 (SQL)


DECLARE @SQL NVARCHAR(MAX);

SET @SQL = 'SELECT A.* FROM DataBook AS A WITH(NOLOCK) WHERE ID = @EID AND Name = @EName';

EXECUTE SP_EXECUTESQL @SQL,
    N'@EID INT, @EName NVARCHAR(100)',
    @EID   = @ID,
    @EName = @Name;

DECLARE @SQL NVARCHAR(MAX);

SET @SQL = 'SELECT A.* FROM DataBook AS A WITH(NOLOCK) WHERE ID = @EID AND Name = @EName';

EXECUTE SP_EXECUTESQL @SQL,

N'@EID INT, @EName NVARCHAR(100)',

@EID = @ID,

@EName = @Name;