sql server - Can I call mysql stored procedure have input paramater in C# without pamameter? -
i want convert stored procedure mssql mysql. in mssql can set default value user-define parameter, mustn't call stored list parameter. in mysql can't that.
for example:
mssql:
create procedure [dbo].[abc] @a datetime = null
=> can: exec abc
mysql:
create definer=`root`@`localhost` procedure `abc`( datetime )
=> must: call abc(value)
anyway call mysql stored procedure in c# without list parameter? because don't want change c# code....
Comments
Post a Comment