blocks|key|499272|text|对于MS+SQL，有SSMS+Tools+Pack，效果很好！|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|499273|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ssmstoolspack.com/^0|A|F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

For MS SQL there is <a href="http://www.ssmstoolspack.com/" rel="noreferrer">SSMS Tools Pack</a>, works great!

blocks|key|1963313|text|一些存储过程生成器：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1963314|常规使用|offset|length|style|BOLD|1963315|1963316|CodeSmith+Generator+-商用software|unordered-list-item|1963317|MyGeneration+-不含free|1963318|Metadrone的|1963319|1963320|特定于SQL+Server的|1963321|1963322|SSMS+Tools+Pack|1963323|Stored+Procedure+Generator|1963324|1963325|另请参见1和2。|1963326|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codesmithtools.com/product/generator|1|http://www.mygenerationsoftware.com/portal/default.aspx|2|http://www.metadrone.com/|3|http://www.ssmstoolspack.com/|4|http://spgen.codeplex.com/|5|https://stackoverflow.com/questions/6393917/free-sql-server-stored-procedure-generator|6|https://stackoverflow.com/questions/785544/any-good-c-sharp-code-generator-for-using-oracle-stored-procedures^0|0|0|4|0|0|0|J|0|0|0|C|1|0|0|9|2|0|0|3|B|0|0|0|F|3|0|0|Q|4|0|0|4|1|5|6|1|6|0^^$0|@$1|2|3|4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1L|8|@$D|1M|E|1N|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1P|8|@]|9|@$D|1Q|E|1R|1|1S]]|A|$]]|$1|L|3|M|5|K|7|1T|8|@]|9|@$D|1U|E|1V|1|1W]]|A|$]]|$1|N|3|O|5|K|7|1X|8|@]|9|@$D|1Y|E|1Z|1|20]]|A|$]]|$1|P|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|22|8|@$D|23|E|24|F|G]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|T|3|U|5|K|7|26|8|@]|9|@$D|27|E|28|1|29]]|A|$]]|$1|V|3|W|5|K|7|2A|8|@]|9|@$D|2B|E|2C|1|2D]]|A|$]]|$1|X|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|2F|8|@]|9|@$D|2G|E|2H|1|2I]|$D|2J|E|2K|1|2L]]|A|$]]|$1|10|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]|18|$5|13|14|15|A|$16|19]]|1A|$5|13|14|15|A|$16|1B]]|1C|$5|13|14|15|A|$16|1D]]|1E|$5|13|14|15|A|$16|1F]]|1G|$5|13|14|15|A|$16|1H]]|1I|$5|13|14|15|A|$16|1J]]]]

Some stored procedure generators:

General use

<ul>
<li><a href="http://www.codesmithtools.com/product/generator" rel="nofollow noreferrer">CodeSmith Generator</a> - commercial software</li>
<li><a href="http://www.mygenerationsoftware.com/portal/default.aspx" rel="nofollow noreferrer">MyGeneration</a> - free</li>
<li><a href="http://www.metadrone.com/" rel="nofollow noreferrer">Metadrone</a> - free</li>
</ul>

SQL Server-specific

<ul>
<li><a href="http://www.ssmstoolspack.com/" rel="nofollow noreferrer">SSMS Tools Pack</a></li>
<li><a href="http://spgen.codeplex.com/" rel="nofollow noreferrer">Stored Procedure Generator</a></li>
</ul>

See also <a href="https://stackoverflow.com/questions/6393917/free-sql-server-stored-procedure-generator">1</a> and <a href="https://stackoverflow.com/questions/785544/any-good-c-sharp-code-generator-for-using-oracle-stored-procedures">2</a>.

blocks|key|1963361|text|你可以试试这个https://github.com/omids20m/FlexiSqlTools，这个应用程序生成CRUD存储过程和搜索存储过程！|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1963362|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/omids20m/FlexiSqlTools^0|7|15|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

you can try this <a href="https://github.com/omids20m/FlexiSqlTools" rel="nofollow">https://github.com/omids20m/FlexiSqlTools</a>
this application generate CRUD store procedures and Search store procedure !

blocks|key|1963449|text|Tools4SQL.net存储过程生成器确实是一个非常好的软件，它为MS+SQL+Server生成了超过10种类型的SP，但它是商业软件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1963450|Demo版本允许为列数少于25的表生成SP。|1963451|Tools4SQL.net+Stored+Procedure+Generator|offset|length|1963452|entityMap|0|LINK|mutability|MUTABLE|url|http://www.tools4sql.net/^0|0|0|0|14|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Tools4SQL.net Stored Procedure Generator is really very good software and it generates more than 10 types of SP for MS SQL Server but it is commercial software.

Demo Version allows to generate SP for Tables which have columns less than 25.

<a href="http://www.tools4sql.net/" rel="nofollow" title="Tools4SQL.net Stored Procedure Generator">Tools4SQL.net Stored Procedure Generator</a>

blocks|key|1963493|text|如果您想要生成存储过程来访问您的关系数据库系统，您应该看看CodeFluent+Entities，它对个人是免费的，看看它是否能满足您的需求。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1963494|该工具允许您相对轻松地生成表、存储过程和视图，并支持Microsoft+SQL+Server、Microsoft+SQL+Azure、Oracle、MySQL和PostgreSQL。|1963495|entityMap|0|LINK|mutability|MUTABLE|url|http://www.softfluent.com/products/codefluent-entities^0|T|J|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

If you want to generate stored procedures to access your relational database system, you should look at <a href="http://www.softfluent.com/products/codefluent-entities" rel="nofollow">CodeFluent Entities</a> which is free for personal and see if it can meet your needs.

This tools allows you to generate tables, stored procedures and views with relative ease
and it supports Microsoft SQL Server, Microsoft SQL Azure, Oracle, MySQL and PostgreSQL.

I am looking for tool which will generate the basic stored procedure structure (CRUD operations) for the given table, Is there any tool for the same?

Stored Procedure generator tool

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在寻找一个工具，它可以为给定表生成基本的存储过程结构(CRUD操作)，有没有工具可以做到这一点？

问存储过程生成器工具
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问存储过程生成器工具EN