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 |
|
abuhassan
105 Posts |
 Posted - 2006-09-08 : 04:55:24
|
| Hiwhat is the difference between SQL and dynamic SQL?Is there difference in performance, efficiency etc?Are dynamic sql more complex to maintain etc? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-08 : 05:09:06
|
| While the SQL is cutie, the dynamic sql is the Pain-in-the-neck to code, to maintain, to understand and to execute !! Does that answer your question? I think the more you will use it, the more you will hate it !Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
abuhassan
105 Posts |
Posted - 2006-09-08 : 05:31:58
|
| what about in terms of performance and effciency? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-08 : 11:36:23
|
quote:
Originally posted by X002548In any case never use dynamic sql, except when you need to.
nice quote!-ec |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Difference SQL and Dynamic sql