Well if you try working with a query using some interface that doesn't support syntax highlighting and you compare this

SELECT T.Field As 'Alilas'

FROM TABLE T

verses this

SELECT T.Field Alias

FROM TABLE T

You'll...

Thats a nice littel utilty there.  I personally would love to see something that can add to this the ability to add table & field aliases using a best pratices...

Thank you Euan!  You are dead on with that answer.  After re-registring the DLL I am no longer having problems with veiwing the properties of a DB via Ent Mgr...

Two thinsg to note:

1) I too had trouble with the DROP Table statement until I used the slanted quotes.  I accidentally discovered that I could also use Brackets to get...

A big thanks to all who have responded.  The situation I describe is unfortunately something I have no control over but still have to work with.  In this scenario the...

..When I refer to SQL, I am referring to the set based SELECT, UPDATE, INSERT, DELETE statements.  When I refer to T-SQL being replaced by CLR, I am referring to...

Straegen, I believe that you recieved the responses you did because your first few posts indicated that you believed that T-SQL was headed for the grave in it's...

David,

You say that dropping the support for the WHERE clause is breaking away from the ANSI standard.  It is the ANSI standard that has pshed the move to using the...

Thanks to both of you for your response.  Let me ask you both this and if anyone else owuld like to chime in then please do so.

If I have a...

I'm inclined to believe that it's not just a fluke that we both have the same problem after installing the Beta.  I'm puttinig my money on their being an issue...

Kenneth, #1 is the technique that I was also recomending.  I was just also pointing out the crwabacks to it; flattening the data.  In the long ruin this is just...

Actually there is a piece of code that will show Stored Procedure dependencies and its available at this website.  The name of the SP is funProcWithoutComments and you can...

I’m curious as to how those who have posted comments stating that the current implementation of the Employee-Job relationship is a bad would change the database or do differently...

You can use SQL's built-in DateTime functions to extract various date values such as Year() which will return the 4 digit year of a date.  In your case your date...