facing some problem in inserting data

• rabbanishaik.net

  SSC Journeyman

  Points: 99

  More actions

  May 28, 2018 at 5:26 am

  #413264

  Hi Team,

  I facing some problem at the time inserting the data,

  for example:

  I insert the one sp into one column of the table its through some exception. please help me

  eg:
  insert into tblSp(Script,Display,Remarks)
  values('Create procedure [dbo].[Delete]
  @Id int = null
  as
  begin
      update master
           set Status=0,
             DeleteDate=getdate(),
               Reason = 'Test '

  end
  ','Delete','new')

  --> it's through exception on  'Test '

  please tell me how to insert the data

• frederico_fonseca

  SSCoach

  Points: 16245

  More actions

  May 28, 2018 at 5:37 am

  #1992103

  you need to escape the single quotes for that field - so 'test' becomes ''test''

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  May 28, 2018 at 7:01 am

  #1992111

  rabbanishaik.net - Monday, May 28, 2018 5:26 AM

  Hi Team,

  I facing some problem at the time inserting the data,

  for example:

  I insert the one sp into one column of the table its through some exception. please help me

  eg:
  insert into tblSp(Script,Display,Remarks)
  values('Create procedure [dbo].[Delete]
  @Id int = null
  as
  begin
      update master
           set Status=0,
             DeleteDate=getdate(),
               Reason = 'Test '

  end
  ','Delete','new')

  --> it's through exception on  'Test '

  please tell me how to insert the data

  Out of interest, can you explain what this table will be used for? Also, what is the @Id variable for?

  ---