Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2010-11-22 : 08:21:44
|
| Hi,Is it possible to store 9 or 10 lines text as a field in sql server..For that any special field type is available?...And for retrieve that field any condition is there?Any Ideas?Thanks ByPARAMUParamu @ PARANTHAMAN |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 08:26:01
|
| You can hold it in a varchar. The lines will be separated by a crlf (char(13),char(10)) probably.The question is probably more about what you want to do with the data rather than how it can be stored.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2010-11-22 : 08:34:41
|
| Hi,Its a kind of requirement, few items descriptions are in detailed manner...So its required to store those details to my StockMaster table...So can I put........... varchar(Max) ?Thanks...Paramu @ PARANTHAMAN |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 08:49:59
|
| Yes - depending on the client.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
hai_venkat
Starting Member
10 Posts |
Posted - 2010-11-22 : 08:50:45
|
| Yes, You can store it in Varchar(Max).Venkat |
|
|
|
|
|
|
Sql Server2008 - Data Type for Multiline text?