Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
android.sm
Starting Member
36 Posts |
 Posted - 2010-10-11 : 05:18:13
|
| are there any free tools that allow us to auto generate stored procedures? do they even excist?thanks... |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-11 : 05:30:35
|
| what do you mean? If you mean something analogous to some languages automatic getter and setter method writing then..... no not really.There are persistence frameworks for different programming languages which try and abstract away the database access code. Like hibernate for java (http://www.hibernate.org/).Personally I hate them. I like having total control over my data and the way that it is accessed. But then I'm a database developer!Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-11 : 05:54:13
|
| Or did you actually mean script *out* stored procs?if so then management stuido can do it. Right click and got to script xyz as....Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
android.sm
Starting Member
36 Posts |
Posted - 2010-10-11 : 06:08:04
|
| not quite an ORM tool. i was wondering if there were any tools that could help us generate stored procedures. a tool that allows you to point to a table and specify the operation (i.e. insert) and it simply generates the insert stored procudure. if you have 100s of tables and needed crud operations on these tables - a tool would significantly help, i'd assume. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-11 : 06:28:12
|
| ah. Check out http://www.ssmstoolspack.com/Very handy and they have jsut what you describe for inserts.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-11 : 06:29:46
|
| http://www.ssmstoolspack.com/Features?f=11Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
android.sm
Starting Member
36 Posts |
Posted - 2010-10-11 : 07:28:51
|
| hey - that looks really good. i will try it out later.thanks for the link! |
|
|
|
|
|
|
|
|
any tools to auto generate stored procedures