말씀을 듣고 sp를 작성했습니다.

-------------------------------------------------------------

create procedure aaa

as

declare @QryStr varchar(255)

select @QryStr = 'select EmpNo, EmpName from Employee '

execute @QryStr

-------------------------------------------------------------

근데 왜 안되죠? 흑흑

The name 'select EmpNo, EmpName from Employee' is not a valid identifier.

라는 메세지만 출력되네요... 엉엉.