SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

The T-SQL Paradigm

By Steve Jones, 2009/04/03

Total article views: 381 | Views in the last 30 days: 13

I ran across this post ranting about T-SQL. It's got going pretty quickly with some less that professional responses. It's cleaned itself up a bit, but it got me thinking for this Friday.

My first programming was done in BASIC. From there I played with a little assembler before going on to Pascal and C in high school. The came LISP, APL, Fortran, more assembler, C++, and a little ADA in college. My professional career had me programming in Lotus 1-2-3, dBase, FoxPro, C, VB, and finally SQL with minor dabbling in HTML, XML, ASP, and some .NET.

I think I've had a decent amount of programming experience in my life. In that time, I've found that most programming languages to work fine, and while I've enjoyed some more than others, I haven't thought that any "sucked." I wouldn't want to write most modern apps in APL, but I don't much think there's any thing wrong with picking VB.NET v Java v C#. So for this Friday's poll:

Is T-SQL really a strange paradigm?

Or SQL in general? Is it really messed up? Would the structures used by LINQ make more sense to anyone? Hardcore developers seem to like a different structure, but is it because it seems more natural to them? Or is SQL really such a strange beast.

Many people seem to have trouble with SQL. Just read the forums here at SQLServerCentral to see all the issues that come when people try to query the database. But is it just hard to learn or is there a better way to build a query language?

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

By Steve Jones, 2009/04/03

Total article views: 381 | Views in the last 30 days: 13
Your response
 
 
Related tags

Design and Theory    
Editorial    
T-SQL    
 
Related content

IGNORE_DUP_KEY

(not yet rated) | 3,041 reads

The Fear of Change

By Steve Jones | Category: Editorial
| 177 reads

Physical join

(not yet rated) | 3,539 reads
 
Contribute

Free registration required...

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Login (existing users)

Login

Email:   Password:   Remember me: Forgotten your password?

Register (new users)

Register

Email:   Password:
Confirm:

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com