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

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -