HEY GUYS! CHECK THIS OUT!!! http://www.sqlcoder.com/ If you work with Microsoft SQL Serverâ„¢ 7.0 or 2000 , the SSCodeGen software can reduce the time you spend coding. SSCodeGen quickly generates code from your database definitions. It is intended to be a no frills, developer's toolbox, providing a quick, easy to understand means of generating code. No installation required (just download and run), it may also be added as an external tool to Query Analyzer or Enterprise Manager. SSCodeGen will : Generate Select, Insert, Update and Delete statements for one or two joined tables. Insert/Update using values, or columns from a table. Translate User Defined Data types. Automatically handle Identity columns. Generate table aliases. Add comments to see column definitions, rules/constraints, and required columns for inserts. Generate the four standard stored procedures for a table and the Visual Basicâ„¢ code to call those stored procedures. Generate code to execute any existing stored procedure, from either SQL, Visual Basicâ„¢ or ASP. LET"S TRY THIS OUT!!! Gaurav
Great tool, simple UI. Has potential of becoming a great piece of software. Serious problem with the primary key or identity limitation. Sure he can easily fix it. Nathan H.O.
Other SQL/VB/ASP Code generators may be found at: 1. http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7077] 2. http://asia.cnet.com/downloads/pc/swinfo/0,39000587,39014857s,00.htm] Interestingly, 3 years ago I started a project of the same kind that would generate VB classes from SQL server tables. You may find it at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=6196&lngWId=1] Nathan H.O.