Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » Not what it see... » Misc   (RSS)
Sorry, but there are no more tags available to filter with.

ORDER BY and VIEWs in SS 2005

Posted Wednesday, June 14, 2006 3:20 PM by michael.k.campbell
ORDER BY has never been technically 'allowed' in a view definition. For example, the following code: CREATE VIEW dbo.[UsersByFirstName] AS SELECT * FROM dbo.[users] ORDER BY [FirstName] GO will throw an error if you attempt to run it. Books Online for Read More...
3 Comments
Filed under: ,

MSDE Pricing

Posted Wednesday, July 06, 2005 2:30 PM by RepeatableRead
One thing I forgot to cover in my previous 'cheet sheet' post of MSDE functionality was any mention of the price. I bring that up because it bit me in the hiney today. On aspadvice I said that MSDE wasn't free, only free-distributable by owners of certain Read More...
1 Comments
Filed under: ,

MSDE v SQLE (plus 8 or 5 concurrent operations?)

Posted Tuesday, May 31, 2005 11:19 PM by RepeatableRead
I'm about to do a couple of posts comparing MSDE against SQL Server Express (or, as I like to call it, SQLE). In these posts I'll cover the facts about MSDE -- in an easy to digest form (I have such a hard time keeping the details straight myself -- I'm Read More...
0 Comments
Filed under: ,