Stored Procedure Generator (for SQL Server 2000/2005)

  •        43

This utility automatically creates all basic stored procedures (SelectAll, SelectRow, InsertRow, UpdateRow, DeleteRow) necessary to access the SQL Server Tables. It also has options to create Data Access Layers for those stored procedures.

http://spgen.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SQL Database script generation for Visual Studio 2008


This project host a Visual Studio Add-In for creating schema scripts, stored procedures and views from SQL Server. Basically, with a couple of clicks you can generate all your tables, stored procedures, and views as individual scripts with DROP/Add statements for foreign keys...

FileSystemHelper SQL Server CLR


FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

DB Compare


DB Compare is a simple utility that compares the schema (Tables, Views, and Stored Procedures) of two SQL Server databases.

jOOQ - Java Object Oriented Querying


jOOQ stands for Java Object Oriented Querying, it effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members. It supports all standard SQL language features including the more complex UNION's, nested SELECTs, joins, aliasing.

Count Widget


CountWidget is a series of C# projects built to demonstrate RAD Studio Code Generation Toolkit to create 100% stored procedure driven data tiers for SQL Server.



NHibernate - object-relational mapper for .NET


NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.

crichey-ActiveDocument


ActiveDocument is an open source Ruby connector for MarkLogic server, although at a later date it could potentially expanded to work with other XML databases. The goal of ActiveDocument is to make it as easy for developers to work with MarkLogic as ActiveRecord makes it for them to work with an RDBMS. The intent is to make them write as little XQuery as possible. If they can get 80% of their tasks done without having to write any XQuery that should increase adoption. Performance is less of a con

ApacheDS - Apache Directory Project


ApacheDS is an embeddable directory server entirely written in Java, which has been certified LDAPv3 compatible by the Open Group. Besides LDAP it supports Kerberos 5 and the Change Password Protocol. It has been designed to introduce triggers, stored procedures, queues and views to the world of LDAP which has lacked these rich constructs.

Sql Server Permissions Auditor


Sql Server Permissions Auditor helps audit permissions on your Sql Server 2005 and up database. The software will audit permissions on tables, stored procedures, and look for several patterns of concern in stored procedures. It requires admin permissions to run. The first ...

Coolstorage - ORM library for .NET


The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

SqlValidator - Check Validity of SQL Server Stored Procedures/Views/Functions/Triggers


Check Validity of SQL Server Stored Procedures/Views/Functions/Triggers

PHPMyAdmin


phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

sqlcc


SQL Code Coverage - SQLCC is a code coverage tool that allows developers the ability to track which lines of code within stored procedures, functions, and triggers have been tested in SQL server by integration tests written by the developer.

sp_CascadingDataViewer


sp_CascadingDataViewer is a stored procedure enables the user to find all data that is dependant on a given set of rows in a given table in a given database. It traverses the database's foreign keys to find that dependant data. It is written in T-SQL and works on SQL Server 2008.

SQL Server Web Tools


SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more.

Data Tier Generator


Microsoft .NET project that generates SQL Server 2000 scripts for stored procedures and C# classes used to access those stored procedures. The stored proecedures generated are as follows: Insert, Update, Delete, Select, SelectByPK, SelectByFK

Sp-Browser - A mini Sql Server Stored Procedure Browser windows application written in c#


A mini Sql Server Stored Procedure Browser windows application written in c#

SPUnit


SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures. The project includes a set of framework stored procedures that provide similar fixture and assertion capabilitieis to the other xUnit f

SQLbuddy – Microsoft SQL Server Management Tool


SqlBuddy is a tool for use with Microsoft SQL Server and MSDE, written in csharp/ DotNet (.NET), to facilitate SQL script writing. It is serves a slightly different purpose that of Query Analyser, in that it is aimed to *help* the user write SQL. It helps to explore the database schema, Organise SQL code and snippets, To expose the in-built SQL Server functionality (functions, procedures etc) to the developer.

100Projects - 100 Projects to be completed, for me its in Python


**Mp3 Tagger** – Modify and add ID3v1 tags to MP3 files. See if you can also add in the album art into the MP3 file’s header as well as other ID3v2 tags.**Log File Maker** – Make an application which logs various statistics in response to given events. This can be something that logs what an application does, what the system is doing, when something like a file changes etc.**Excel Spreadsheet Exporter** – Create an online application which can read in a file and create an Excel Spreadshe