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 |
|
chadmat
The Chadinator
1974 Posts |
 Posted - 2003-11-20 : 11:31:58
|
| http://weblogs.asp.net/fbouma/posts/38178.aspx-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-20 : 12:38:45
|
| very interesting indeed .... i think like anything you should never be 100% "pro" or "con" towards ANYTHING. every situation has its benefits and drawbacks to a particular approach; to be locked in 1 way of doing things without objectively thinking about it isn't a good thing in my opinion.- Jeff |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-11-20 : 12:44:33
|
| Whoa...good read..but seriously...come onDid the developers build the ER Model, do they understand the data dictionary, ect, ect...Building dynamic sql? I'd like to see them "build" some of the solutions offered up here...Not to mention some of the basic design issues of the dbs themselves..and developers asking...how do I get the middle 200 rows...sheesh...At least there's a good cursor bashing in there...Brett8-)EDIT: Jeff, staying away from the 100% thing...ok, gotta agree...but what can't you do with a sproc that you can do with dynamic sql?And I love the argument about how difficult it is to build and maintain sprocs...what a load...how difficult is it to have to restore the database becuase the dynamic sql blew away all the data..We've all seen the posts...how do I rollback a delete I did? I forgot the WHERE clause...ummm...ROLLBACK TRAN? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-20 : 13:00:46
|
quote:
Originally posted by X002548
We've all seen the posts...how do I rollback a delete I did? I forgot the WHERE clause...ummm...ROLLBACK TRAN?
I went to an Oracle presentation a little while ago and they mentioned a new feature coming out in 10g or 11g (can't remember which one). It is called flashback query. It allows you to undo a statement without being inside a transaction. So after it is committed, you can still undo it. They didn't provide much detail, but it sounded pretty cool. I guess it would be similar to what LogExplorer allows you to do but without having to buy a third party product.Tara |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-11-20 : 13:06:12
|
| Crazy stuff, were the pro dynamic sql sides pimping GUI tools?Tenacious O |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-20 : 13:24:13
|
quote:
EDIT: Jeff, staying away from the 100% thing...ok, gotta agree...but what can't you do with a sproc that you can do with dynamic sql?
you design a modelling or budgetting or allocations system or something that does complex calculations ... the user can pick how they'd like to perform different calculations for each cost center or group or whatever by entering complex expressions: for example, for group1 it's(col1 * col2 - col3 / col4), for group 2 it's (col1 - col2 / col3). I'd use heavily validated dynamic SQL to accomplish this.On another project, I needed to let the user build complex boolean conditions for the data they'd like returned for ad-hoc queries... they don't hand enter it, but they pick the field, the operator, choose a list of values, and combine things with AND's and OR's .... the final statement is built via dynamic SQL.Stuff like that ... definitely not the basic "let the users choose a report sort or criteria" kind of things .....- Jeff |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Interesting debate