Maneesh A N

Maneesh A N

  • NA
  • 179
  • 108.6k

error sql 2005in dynamic query

Dec 12 2013 5:39 AM
alter procedure prcEmpView
(
  @Wherecondition nvarchar(4000)
)
as
begin
declare @sqlquery nvarchar(4000)
set @sqlquery=
 'select
         vEmpName,
         vAddress,
         vPhone,
         vEmail
 from  tblEmployee
'+@Wherecondition
 execute sp_execute @sqlquery
 end


pls correct as soon as possible

Answers (4)