Operational parameters of the MS SQL procedure



  • Got it. SqlCommandBuilder.DeriveParameters(cmd) which fills SQL Command with the procedural arguments. Is there any way we can figure out what's opportunistic and what's not?



  • No. SqlCommandBuilder.DeriveParameters(cmd) https://referencesource.microsoft.com/#System.Data/System/Data/SqlClient/SqlCommand.cs,faa7cb5d3974c14a Uses the challenge of the preserved procedure sp_procedure_params_100_managed to get a list of parameters. And the results of the challenge. sp_procedure_params_100_managed There's no opportunity flag.

    I mean. DeriveParameters I don't know anything about the opportunity of the parameters and adds everything to the team.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2