| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-13 : 06:44:50
|
51 minutes?Can you post the highlights?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
pootle_flump
1064 Posts |
Posted - 2009-05-13 : 12:34:31
|
| Heh - I was just looking for that vid, and google brought me here. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-05-13 : 12:45:22
|
hahaha. nice  well the bottom line is use sprocs by default unless you have a really good reason not to use them.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-13 : 13:11:56
|
Like n-tier enterprise Microsoft Access applications?Wow, that made me remember Microsoft Access do not have stored procedures. They are called queries.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-13 : 13:20:37
|
| Well, it doesn't have an optimizer either, so you don't really need sprocs.At least that's what Joe Celko said 11 years ago... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-05-13 : 15:10:47
|
| I'm very disappointed that whitefang never responds when I start debating (baiting) him.I guess n-tier Enterprise Level architects are just too serious to want to play.CODO ERGO SUM |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-05-14 : 07:24:56
|
| Yea, and you locked the thread where he tried to say I was using the appeal to authority fallacy. I never got to tell him he was a hypocrite and that I was ridiculing his citing a source, then stating the OPPOSITE of what it said...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124387[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-05-14 : 10:56:19
|
Saw the start of that one. Just caught up with it.  [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-05-14 : 14:29:38
|
quote:
Originally posted by Peso
Like n-tier enterprise Microsoft Access applications?Wow, that made me remember Microsoft Access do not have stored procedures. They are called queries.
Access queries are akin to SQL Server views, not sprocs. To implement anything sproc-like you'd have to do it in a VB code module.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-14 : 18:44:41
|
| You can add parameters to Access queries and it will prompt you when you run it. You can then pass parameters to it via VB script or from a form. I think you can do it with an Access (non-VB) macro too, can't remember. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2009-05-15 : 05:15:02
|
quote:
Originally posted by Peso
Wow, that made me remember Microsoft Access do not have stored procedures.
Actually, JET does support stored procedures...however, they must be inline (no multi line statements in JET SQL) so they are absolutely **** all use unless you just want to obfuscate your application (IIRC they don't appear in any of the Access windows). |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-05-15 : 14:52:05
|
quote:
Originally posted by robvolk
You can add parameters to Access queries and it will prompt you when you run it. You can then pass parameters to it via VB script or from a form. I think you can do it with an Access (non-VB) macro too, can't remember.
You can query a view with parameters as well, and the prompting is just part of the built-in GUI.Point is, Access queries must be single step statements, like views. You can't do multi-step processing or any of the other complex actions that can be done in sprocs unless you put them in a VB module.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
The Pros and Cons of Stored Procedures