Sunday, August 26, 2007
SELECT Top(10) *
FROM [Order Details]
ORDER BY [Unit Price] * Quantity DESC
And you will get the 10 most valuable orders listed.
It's nice to see this omission finally added to the SQL Compact syntax.
Wednesday, August 15, 2007
This new feature is not mentioned anywhere, but listed in the docs:
sp_rename: Changes the name of a user table in the current database. Currently, sp_rename support in SQL Server Compact 3.5 is limited to tables.
sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' [ , [ @objtype = ] 'object_type' ]
In the following example I will demonstrate it's use (using the VS 2008 beta 2 Server Explorer):
But runs the query none the less.
Do a refresh...
And voila... all from plain old T-SQL!
Tuesday, August 7, 2007
This is the "classic" dialog from SQL CE 3.1
(click to enlarge)
Notice the two new pages, a "Add Relations" page.
And a "Manage Relations" page.
This is a nice addition to the SQL Compact Management UI - and is a missing piece requested by many users.