I haven't tried it yet but can you do a select of the field while casting to an xml datatype?

Oh wow... I can remember thinking that when I first started using SSMS. Now I get so frustrated with EM if I have to use it. I love...

No, it's not because of constraints. I verified that it won't let you modify any data unless you've only got one table open. I wish it weren't so.

I just gave it a try and SSMS wouldn't allow an update even on an updateable query.

If you want to be able to edit your data in grid format you...

I haven't actually tried editing joined tables in SSMS but you might consider the type of joins you have. In some cases when two or more tables are joined...

With the new ROW_NUMBER() feature in 2005 a lot of my select procedures have multiple select statements in them and only differ by the order by clause. So in...