我使用的是 SQL Server 2008 R2.是否有免费的脚本/实用程序可以为我的所有数据库表制作 CRUD SP?我曾经有一个,但脚本丢失了.
I am using SQL Server 2008 R2. Is there a free script/utility which can make CRUD SPs for all of my database tables? I use to have one but lost the script.
谢谢
我使用 SSMS 工具包,CRUD 生成器只是我经常使用的众多功能之一.您还可以自定义它用于创建 CRUD SP 的模板.
I use SSMS Tools Pack, a CRUD generator is only one of the many features it has that I use on a regular basis. You can also customize the templates it uses to create the CRUD SPs.
这篇关于用于 SQL Server 2008 (R2) 的 CRUD SP 生成器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持html5模板网!
将每个子标记转换为具有多个分隔符的单列-SQLConverting Every Child Tags in to a Single Column with multiple Delimiters -SQL Server (3)(将每个子标记转换为具有多个分隔符的单列-SQ
如何从多个表创建视图?How can I create a view from more than one table?(如何从多个表创建视图?)
根据前一行内的计算值创建计算值Create calculated value based on calculated value inside previous row(根据前一行内的计算值创建计算值)
如何将表格的前两列堆叠成一列,但也仅将第三How do I stack the first two columns of a table into a single column, but also pair third column with the first column only?(如何将表格的前两列堆
递归 t-sql 查询Recursive t-sql query(递归 t-sql 查询)
将月份名称转换为日期/月份编号(问题和答案的组Convert Month Name to Date / Month Number (Combinations of Questions amp; Answers)(将月份名称转换为日期/月份编号(问题和答案的组合