SQL Table Trouble?

Question

its kind of hard to explain but i will try break it down.

i have a table set up with 5 colums on my sql server

Name | Location | Email | URL | Comments |

with the Comments field i want it to hold over say 100 characters

but when i go to view whats been added to the table
everthing is in one very long straight line


how do i set up the fields so i can perfectly see every thing nice and neatly in each field

something with multilines.

Answer 1

That depends on how you're viewing the data. Remember, the database only holds the data, something else does the presentation. (Well, something else may be part of the dbms.)

I don't know SQL Server, but in Oracle's SQL*Plus, you'd define the column as x characters with data wrapping. Whenever it was selected, the data would wrap lines with each line being x number of bytes.

Answer 2

Sorry my friend it is not possible in SQL server. Reason is when a give some select command it gives the result which we called record and over there if any fields contains more character it will show in a line as a part of the record and multi line is not possible. In SQL data result can show in grid and text view, so you can change the view from the grid to text but result is same but in text you can see all the character that the field contains. (From Query menu you can change the results view)

Answer 3

just after assigning the data type of the cell , you should choose the lenght of the string to be inserted.

Answer 4

use varchar for comments