where caluse help please.

• Shiv-645170

  Mr or Mrs. 500

  Points: 528

  More actions

  February 20, 2008 at 6:38 am

  #182352

  Hi,

  Sorry this has been posted twice. The Moderator can delete one .

  Can some one tell me how I can pass a integer value to where clause in a stord procedure.

  For Example

  __________

  ALTER PROCEDURE sp_Sample

  (

  @Empid nvarchar(100)

  )

  AS

  Declare @STR varchar(1000)

  Begin

  set @STR = 'SELECT * from Employee WHERE empid=' + @Empid

  Exec (@str)

  end

  Go

  now when executing i want to get the empid to be like select * from employee where empid= 'A1234'

  instead where am getting like empid = A1234

  How can i get the single qoute there while executing....

  Thanks,

• dragos_sv

  Default port

  Points: 1478

  More actions

  February 20, 2008 at 6:50 am

  #780174

  you have to add the simple quotes to the string

  so, the string changes to:

  set @STR = 'SELECT * from Employee WHERE empid=''' + @Empid + ''''

  the quotes are escaped