T-Sql rant

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » T-Sql rant

466 posts, Page 1 of 47

1 2 3 4 5 »»»

T-Sql rant

Rate Topic

Display Mode

Topic Options

Author

Message

foxjazzG

Posted Friday, March 13, 2009 1:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 26, 2012 11:44 AM
Points: 158, Visits: 291

Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how you like it. (or the t-sql language which really is the worst language MS has ever put on the block). I really don't understand why the sql server group didn't do a better job of it, or is it because they were taking thier queue from ORACLE.

Really stupid paradigm if you ask me, and I think it needs to be improved upon.

Post #675554

John Rowan

Posted Friday, March 13, 2009 2:10 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

As it stands, T-SQL is about the most simple language on the planet. Specifically, what problems are you having that you feel are the languages fault?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #675563

Lynn Pettis

Posted Friday, March 13, 2009 2:13 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 21,615, Visits: 27,445

So, what don't you like about T-SQL? I find it quite easy to work with and haven't had any problem moving from a 3GL language (COBOL) to it.

The paradigm behind SQL (T-SQL) is completely different from working with a 3GL language but make total sense when working in a set oriented environment.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #675567

Steve Jones - SSC Editor

Posted Friday, March 13, 2009 2:23 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

T-SQL comes from SQL. It was developed by Sybase, not MS. It's similar to PL-SQL, which Oracle uses, but there are substantial differences.

A query language, working with sets of data, is fundamentally different than a programming languages like C#.

There are plenty of developers who think C# is a beast and a POS compared to other things. It's likely a preference thing. Each of us probably works with different types of languages and paradigms in different ways and prefers some.

I, like the others, would be interested to know what specific issues you have.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #675573

GSquared

Posted Friday, March 13, 2009 2:27 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

OO Querying... what would it look like:

Create Object qqMyQuery as Query;
qqMyQuery.addtable.Table1;
qqMyQuery.addtable.Table2;
qqMyQuery.addtable.Table3;
qqMyQuery.tables.addjoin(Type="Inner","Table1,Table2");
qqMyQuery.tables.joins.addcriteria(Table1.Col1,Table2.Col2);

And so on. Is something like that what you're looking for? Where you'd create objects based on definitions, and then would have to access methods and assign properties?

Frankly, I don't think that works so well. If you really want to try it out, download the free trial of Cache. It's an OO DB. Instead of tables and columns, it has objects and properties. You can do things like "MyTable.Col1.value=1", instead of the T-SQL "update MyTable set Col1 = 1". Data storage is all multi-dimensional arrays. It's designed to work with .NET directly.

If you don't like SQL, try it. Seriously.

Personally, I've done so, and I'm sticking with SQL, for the simple reason that it's a LOT easier to build and operate a database in it. For me, anyway.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #675576

foxjazzG

Posted Friday, March 13, 2009 2:29 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 26, 2012 11:44 AM
Points: 158, Visits: 291

are you guys living in the cage of t-sql? :)))

well begin and end for one can be replace with { }

declare @whatever as int can be replace with
int @whatever

gee I just shortened it by two whole words.

set @i = 1 can be replaced by @i = 1 (which it has in sql 2008) about freaken time.

Shall I go on, or can you get the idea?

Post #675578

foxjazzG

Posted Friday, March 13, 2009 2:34 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 26, 2012 11:44 AM
Points: 158, Visits: 291

also instead of using cursurs like they are now, wouldn't it be easier to say:

foreach( select myfield from tbl where myotherfield > 3)
{
insert into myothertable (myotherfield) values (myfield)
}

I think it would be easier if this were the case. No GSquared, I like t-sql, but I think it could easily be made a lot more powerful if the t-sql guys would have just get off their asses and did something significant.

Post #675584

Lynn Pettis

Posted Friday, March 13, 2009 2:34 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 21,615, Visits: 27,445

Your complaints are a bit of the mark IMHO. There is nothing wrong with the sematics of T-SQL. It's just different the C# just like C# is different from VB.NET or any of the other varied languages that exist in the world.

Now, what really bothers you about SQL?

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #675585

Lowell

Posted Friday, March 13, 2009 2:36 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 11,638, Visits: 27,712

the only things you identified so far is a slight shortening of a couple of keywords....saving a handful of keystrokes doesn't mean that's an improvement, just a preference.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #675587

Lynn Pettis

Posted Friday, March 13, 2009 2:37 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 21,615, Visits: 27,445

foxjazz (3/13/2009)

Most of us SQL guys (and gals) don't use cursors to update tables. That is SO RBAR and inefficient in SQL Server.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #675589

« Prev Topic | Next Topic »

466 posts, Page 1 of 47

1 2 3 4 5 »»»

Permissions