June 28, 2007 at 2:52 pm
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/additional/3081.asp
Brian Knight
Free SQL Server Training Webinars
July 11, 2007 at 11:33 am
Am I the only person who thinks this is a poor article?
To quote:
"But the problem with T-SQL is that programmers already have enough to learn, much less having to master another language for storing and executing code in databases. T-SQL is a crude version of some higher-level languages such as Visual Basic, but gets the job done with fundamentals."
NO - T-SQL is a SET BASED language which is strong at handling tuples of data - which is what the Relational Model is all about.
"SqlCommand cmd = new SqlCommand("SELECT * FROM
dbo.Widgets", conn);"
SELECT * - no need to say more about that. But are we really saying that all select statement now needs to be compiled in c# code, then deployed as assemblies, just so developers don't need to learn T-SQL?
I am not anti-CLR. CLR can be great - when you need it. My current thinking is: Explain why your C# code should not be in the application tier. Explain why it should be c# and not T-SQL. If both of those criteria are met, THEN consider CLR.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply