sql - Blank Characters in Stored Procedure Arguments -


I have written a stored procedure, which has two arguments that are both strings, strings can contain one or more spaces For example:

  exec usp_arch_ptask_assign_me system administration, workflow process manager   

or

  exec usp_arch_ptask_assign_me 'system administration' , 'Workflow process manager'   

or

  exec usp_arch_ptask_assign_me [system administration], [workflow process manager ]   

The first attempt gives a syntax error and the second and third attempt asks the stored procedure to think that the attached characters are part of the actual parameter value.

Suggestions? Thanks!

  USE DATABASE_NAME; Go acac usp_arch_ptask_assign_me 'system administration', 'workflow process manager'; Go    

Comments

Popular posts from this blog

c++ - Cmake produces file extensions in static library archives -

c# - Roxy file manager in MVC doesn't accept session path -

c# - XML - Serialize class - Some questions -