用我的sql创建存储过程 [英] create store procedure with my sql

问题描述

DEFINER = example root @ localhost
塔贝尔名称:供应商
文件名:
1.SUP_NO Varchar(10)
2.SUP_Name Varchar(20)
3.Date_EN日期
4.地址Varchar(30 )
我正在学习使用Visual Studio制作项目，
通过使用MY SQL数据库.
我想通过参数使 storeprocedure 从上表运行sql 插入命令.
如何制作存储过程?以及如何调用?
请从老年人那里获得帮助.

DEFINER=example root@localhost
Tabelname :SUPPLIER
Filed name :
1.SUP_NO Varchar(10)
2.SUP_Name Varchar (20)
3.Date_EN Date
4.Address Varchar (30)
I''m learning to make a project with visual studio,
by using the MY SQL database.
I want to make storeprocedure to run the sql insert command from the table above by the parameter.
"How do I make the storeprocedure?? and how is calling?
Please help from seniors

推荐答案

要创建过程，请参见: Call [ ^ ]

有关插入语句，请参见: INSERT [ OleDbCOmmand [ ^ ]和方法 ExecuteNonQuery [

To create a procedure see: CREATE PROCEDURE[^] and to call it see CALL[^]

For the insert statement see: INSERT[^]

To call the procedure from VB.NET use for example OleDbCOmmand[^] and the method ExecuteNonQuery[^]

您好ZeroSeven08
通过Visual Studio上的服务器资源管理器创建存储过程.看看
有-[使用Visual Studio的Server Explorer创建SQL存储过程] [链接 [链接 [

Hi ZeroSeven08
To create store procedure via server explorer on Visual studio. take a look
There-[Using Visual Studio’s Server Explorer to Create SQL Stored Procedures][^] and this link[^] also might help you.


I''ve mentioned about SQLserver database but your question is about MYSQL so this link [^] will be useful for you.
[/Edited]

这篇关于用我的sql创建存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！