MSSQL에서 동적SQL을 구현(OUTPUT파라미터 있을때)
sp_executesql 라는 스토어드 프러시져를 사용하면 됩니다. 밑에는 실제 프로젝트에 사용했던 프로시져입니다...^^ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- CREATE procedure p_GetValue ( @tagName as nvarchar(20), @mode as real output, @sp as real output, @pv as real output, @ivp as real output, @alm_a as real output, @alm_b as real output, @alm_c as real output, @alm_dbnd as real output, @mvp as real output, @out as real ..
더보기