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 |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2004-09-05 : 21:16:19
|
| Hello All,What is the best way to access database from application?Writing SQL queries in Application code or Stored Procedures.Thanksmk_garg |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-05 : 21:19:20
|
| Stored procedures. Without a doubt.I would write a couple of custom procedures for executing SP's.You can also push some of your data-intensive processing into SP's so your server takes the load and not your app. |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-05 : 21:30:55
|
| ThanksJust reading on following linkhttp://www.sommarskog.se/dynamic_sql.html#Why_SPmk_garg |
|
|
|
|
|
|
Database access from application