MS SQL XML - SQL 2005 Table Formatting

Author

SQL 2005 Table Formatting

LvBohemian

2006-01-27, 8:24 pm

I am sure this is just some kind of configuration setting or something
similar; what I would like to do is define a 2005 table with text or
varchar(max) or something similar and be able to paste paragraphs of data
into a field for example and then be able to manually open the table from
Microsoft Management Studio and expand the row and be able to read it like a
page in a book so to speak...

as simple a task as this seems to be; I have not figured it out yet; when I
copy a couple of sentences that break over multiple lines for instance into a
new row just using basic windows copy and paste functionality, only the first
line of the text pasted is visible...

I am looking for something that works like FoxPro memo fields or how sql
2000 works...

Thanks in advance.

Adam Machanic

2006-01-29, 3:23 am

SQL Server Management Studio is not a data entry interface. It is designed
for database management. I think you might want to research using a product
such as Access as your front end.

--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

"LvBohemian" < LvBohemian@discussio
ns.microsoft.com> wrote in message
news:3E4FCE5D-FB53-4AC9-9E6D- 5C914882B697@microso
ft.com...
>I am sure this is just some kind of configuration setting or something
> similar; what I would like to do is define a 2005 table with text or
> varchar(max) or something similar and be able to paste paragraphs of data
> into a field for example and then be able to manually open the table from
> Microsoft Management Studio and expand the row and be able to read it like
> a
> page in a book so to speak...
>
> as simple a task as this seems to be; I have not figured it out yet; when
> I
> copy a couple of sentences that break over multiple lines for instance
> into a
> new row just using basic windows copy and paste functionality, only the
> first
> line of the text pasted is visible...
>
> I am looking for something that works like FoxPro memo fields or how sql
> 2000 works...
>
> Thanks in advance.
>

LvBohemian

2006-01-29, 8:23 pm

I don't want to use it as a data entry interface per se, I am just curious if
for instance I have some piece of text to change a typo in; that it would be
nice to be able to open up the row/column directly and quickly change the
text...

This is a feature that has existed in SQL Server previous to the 2005
edition, and many other databases, that simply appears to be an oversight in
the grid design that the SQL O5 team shipped...

Moreover, if one is developing something and they want to quickly see how
some text might be represented in a row in a SQL 2005 table, by simply
copying & pasting it, one would not expect to have everything after the first
row truncated…

The first thing that comes to mind is there is some hidden configuration
option that is not well documented yet to be found…

Further in trying to migrate an extensive legacy FoxPro system to SQL 2005,
it’s a hard sell when this particular desired feature exists in all versions
of FoxPro but appears at present to be depreciated or overlooked from SQL
2005.

My question remains; can this be done or not in SQL Server 2005?

Thanks in advance.

Adam Machanic

2006-01-30, 8:24 pm

"LvBohemian" < LvBohemian@discussio
ns.microsoft.com> wrote in message
news:160D0E09-E8BE-43D4-A72D- D73BC5AFD0C7@microso
ft.com...
>
> My question remains; can this be done or not in SQL Server 2005?

Of course.

UPDATE YourTable
SET YourTextCol = 'YourNewValue'
WHERE YourPK = 'YourPKValue'

SQL Server is a DBMS; it is not a data entry user interface. SQL Server
is not Access, and it is not FoxPro. In my opinion, removing those features
from SSMS was a good thing -- I've seen them cause a lot of problems in many
projects I've worked on, in which users thought they were just making
"quick" changes and ended up corrupting data. I think in the long run that
forcing users to do things the "right" way will have a positive effect on
data quality.

--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

Sponsored Links