Remove non printable characters

• Kristen-173977

  SSCrazy Eights

  Points: 8687

  More actions

  November 4, 2015 at 5:50 am

  #1837618

  mbaldock (11/4/2015)

  ---

  but there are no database objects referenced by the function!

  My understanding is that you get a better performing Query Plan (no SPOOL) if you use SCHEMABINDING.

• dhart

  SSC Journeyman

  Points: 98

  More actions

  June 12, 2018 at 2:06 pm

  #1993774

  Paul White:
  How do I actually use your inline table function?

  After the creating the function, I ran this:

  DECLARE @Bitbucket VARCHAR(8000);
  SELECT @Bitbucket = iTVF.cleaned
  FROM  [vdvPosPayPNCBank_RKL] D
  CROSS
  APPLY dbo.IF_CleanWithReplace(D.PayeeName1) iTVF;

  which simply returns 'Commands completed successfully.'

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  June 12, 2018 at 2:21 pm

  #1993779

  dhart - Tuesday, June 12, 2018 2:06 PM

  Paul White:
  How do I actually use your inline table function?

  After the creating the function, I ran this:

  DECLARE @Bitbucket VARCHAR(8000);
  SELECT @Bitbucket = iTVF.cleaned
  FROM  [vdvPosPayPNCBank_RKL] D
  CROSS
  APPLY dbo.IF_CleanWithReplace(D.PayeeName1) iTVF;

  which simply returns 'Commands completed successfully.'

  That's just assigning values to the variable. It's a method to test execution times. To actually return rows, use a proper column list instead.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2