My friend told me about a tool that will auto-generate insert/update/delete stored procedures for SQL Server 2005, but he doesn't rememeber the name. Does anyone know of such tool, it is supposedly a free tool and is independent from Microsoft.
2006-10-23 14:58:32 · 3 answers · asked by Iamverybroken 2 in Computers & Internet ➔ Programming & Design
IT Pro, is it possible to do with actual Visual Studio 2005. It seems to me that if can do it using express, one can do it with Visual Studio.
2006-10-23 15:04:27 · update #1
Joey Madison, you are right, however it does not take into consideration the relationships on table. It does create a simple statement, but not a stored procedure for that.
2006-10-23 15:06:33 · update #2
MS Visual Web Developer 2005 Express will do just that.
2006-10-23 15:00:48 · answer #1 · answered by IT Pro 6 · 0⤊ 0⤋
You can use Query Analyzer (it comes with SQL). Right click on the table you need to create the stored procedure for and you will see some menu items that allow you to insert a script into a new window....
You can also use Visual Studio but you will need a separate license...
Hope this helps!
2006-10-23 22:01:53 · answer #2 · answered by Joey Madison 2 · 0⤊ 0⤋
build your tools by yourself , it's not difficult.
you know how to get list of field and field type from a table, you know the table name, and you know insert/update/delete query for stored procedure, just use your imagination to combine it all.
2006-10-24 04:23:37 · answer #3 · answered by Manzana verde 5 · 0⤊ 0⤋