SQLDJ products are developed by developers for developers. The SQLDJ SQL Server Code Writer eliminates the need for database developers to spend unproductive time developing base stored procedures. SQLDJ SQL Server Stored Procedure Writer generates stored procedure code for your SQL Server database. It supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012. SQLDJ SQL Server Stored Procedures Code Writer automatically generates advanced SQL Server stored procedures based on user selected database, database schema, tables. What Types of Stored Procedures does SQLDJ Code Writer generate? SQLDJ Code Writer generates Select, Delete, Update, UpdateAll, List, ListAll, Search stored procedures. Stored procedures List, ListAll, Search stored procedures support custom paging. Search stored procedures support User Defined Table Types parameters for SQL Server 2008, 2008 R2, 2012. User Selectable Options to Generate Stored Procedure: 1. Grant Execute Stored Procedure to Database User. 2. Transaction Handling. 3. Identity Backward Compatibility for MS SQL Server 2000, 2005, and not patched 2008, running on Windows Server 2008 with no SP. Addresses @@IDENTIY issue. 4. Stored Procedure Encryption. 5. Stored Procedure Start and/or End Transaction Isolation Level. 6. Create Stored Procedure in the database and/or Save the generated script to File for all tables in the database schema. 7. Support for different database schemas. 8. Generates UDTT for Search Stored Procedures. 9. Advanced paged SELECT in List, ListAll Stored Procedures. 10. Advanced Search capabilities with Search Stored Procedures.
Requirements:
.NET 4.0 Client Profile, Microsoft SQL Server 2005 or later
Limitations:
5 tables per database
Comments not found