SQL Server Functions

• MuhammadShafiq

  SSCrazy

  Points: 2509

  More actions

  September 28, 2011 at 7:00 am

  #244597

  Hi,

  i have a scalar valued function 'split_string'.

  i want to check it either it is working or not? how i will execute it?

  like we can do in SP

  exec spName;

• Lowell

  SSC Guru

  Points: 323522

  More actions

  September 28, 2011 at 7:05 am

  #1387724

  well it depends on the function for the exact parameters allowed, but for exampleit would typically be something like this:

  SELECT dbo.split_string('A String, To Split',',')

  --where the second parameter(the comma) is what to split it on.

  --if it was a table value function, it would be very similar:

  SELECT MyAlias.* FROM dbo.split_string('A String, To Split',',') MyAlias

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• MuhammadShafiq

  SSCrazy

  Points: 2509

  More actions

  September 28, 2011 at 7:13 am

  #1387738

  Done:

  Thank you..you save my time