Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2686, trackbacks - 64

My Links

Advertisement

News

Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

An interesting take on "Stored Procedures" (link)

Another great post SQL-related post over at TheDailyWTF regarding a, umm, "creative" use of "Stored Procedures":

http://thedailywtf.com/Articles/For-the-Ease-of-Maintenance.aspx


Print | posted on Monday, November 16, 2009 1:42 PM | Filed Under [ Humor Links ]

Feedback

Gravatar

# re: An interesting take on "Stored Procedures" (link)

It doesn't seem possible that it is real. And if it is real, then I take offense at the person calling him/herself a DBA as no good DBA would ever recommend/promote something like that with all of the security and performance implications.
11/17/2009 1:59 AM | Tara
Gravatar

# re: An interesting take on "Stored Procedures" (link)

Hilarious! Must be lovely working with that DBA! :-)
1/2/2010 4:25 PM | Giammarco Schisani
Gravatar

# re: An interesting take on "Stored Procedures" (link)

Is there any truth to this story? Since I'm not familiar with the %1% syntax. It was written on April Fool, but the ACCT_ID is numeric and its data is passed in as string.

If this syntax works, it actually solves a lot of problems for me since I'm trying to create dynamic ORDERY BY for my paging queries. I can't imagine how the query3 is written though since %1% is not a parameter.
8/17/2010 4:11 PM | Johnny
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET