Is it possible to specify parameter Bind in SQL Server?

Asked 2 years ago, Updated 2 years ago, 97 views

We are developing a database operation program at C#.
Oracle sets OracleCommand's BindByName to true to
by parameter naming I think it is possible to set parameters, but is there an option like this in SQL Server?
In the case of SQL Server, I would like to know if it is possible to set parameters by specifying parameter names.

c# sql-server oracle

2022-09-30 11:44

1 Answers

Using Placeholders with Parameters, as explained in

  • SqlCommand=@parameter
  • OleDbCommand=?
  • OdbcCommand=?
  • OracleCommand=:parameter

will be

2022-09-30 11:44

If you have any answers or tips

Popular Tags
python x 4647
android x 1593
java x 1494
javascript x 1427
c x 927
c++ x 878
ruby-on-rails x 696
php x 692
python3 x 685
html x 656
Popular Questions

569 rails db:create error: Could not find mysql2-0.5.4 in any of the sources

877 /usr/bin/google-chrome:symbol lookup error:/usr/bin/google-chrome: undefined symbol:gbm_bo_get_modifier

580 PHP ssh2_scp_send fails to send files as intended

586 Scrap text information after the "View More" button when searching in the Yahoo! News search window

1019 In Java servlet, when SHA-256 sends WW-Authenticate header for digest authentication, the client does not return the result.

© 2024 OneMinuteCode. All rights reserved.